i am trying to export database.i am using arabic in my databse .
my database
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
client charaterset
oracle 6i on windows10 machine
AMERICAN_AMERICA.WE8ISO8859P1
database charaterset
SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
VALUE$
-----------------------------------------------------------------------------
WE8MSWIN1252
please if anyone can help me for this . this very urgent for me.
i am getting the following error
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
About to export specified users ...
User to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
export (when run on a client machine) will use the settings on the *client* to convert data if it differs from the database characterset.
If you do not want any conversion, then you can either:
a) run the export on the database server, or
b) set the client characterset to the same as the database, and then run the export
C:\Users\hamcdc>exp userid=scott/tiger
Export: Release 12.2.0.1.0 - Production on Sun Mar 26 18:22:18 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
C:\Users\hamcdc>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
C:\Users\hamcdc>exp userid=scott/tiger
Export: Release 12.2.0.1.0 - Production on Sun Mar 26 18:23:59 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT