rac2-> export NLS_LANG=AMERICAN_AMERICA.UTF8rac2-> exp hr/hr owner=hr file=hr1.dmp grants=y
Export: Release 10.2.0.1.0 - Production on Wed Jul 8 13:52:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsExport done in UTF8 character set and AL16UTF16 NCHAR character setserver uses AL32UTF8 character set (possible charset conversion). exporting pre-schema procedural objects and actions. exporting foreign function library names for user HR . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user HR About to export HR's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export HR's tables via Conventional Path .... . exporting table COUNTRIES 25 rows exportedEXP-00091: Exporting questionable statistics.. . exporting table DEPARTMENTS 27 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table EMPLOYEES 107 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table JOBS 19 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table JOB_HISTORY 10 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table LOCATIONS 23 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. . exporting table REGIONS 4 rows exportedEXP-00091: Exporting questionable statistics.EXP-00091: Exporting questionable statistics.. exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully with warnings.rac2->
解决方法:
SQL> l 1* select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'SQL> /
PARAMETER------------------------------VALUE--------------------------------------------------------------------------------NLS_CHARACTERSETAL32UTF8
SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
PARAMETER----------------------------------------------------------------VALUE----------------------------------------------------------------NLS_CHARACTERSETAL32UTF8
SQL>
SQL> show parameter nls
NAME TYPE VALUE------------------------------------ ----------- ------------------------------nls_calendar stringnls_comp stringnls_currency stringnls_date_format stringnls_date_language stringnls_dual_currency stringnls_iso_currency stringnls_language string AMERICANnls_length_semantics string BYTEnls_nchar_conv_excp string FALSEnls_numeric_characters string
NAME TYPE VALUE------------------------------------ ----------- ------------------------------nls_sort stringnls_territory string AMERICAnls_time_format stringnls_time_tz_format stringnls_timestamp_format stringnls_timestamp_tz_format string
rac2-> export NLS_LANG=AMERICAN_AMERICA.AL32UTF8rac2-> exp hr/hr owner=hr file=hr3.dmp grants=y
Export: Release 10.2.0.1.0 - Production on Wed Jul 8 13:55:25 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining optionsExport done in AL32UTF8 character set and AL16UTF16 NCHAR character set. exporting pre-schema procedural objects and actions. exporting foreign function library names for user HR . exporting PUBLIC type synonyms. exporting private type synonyms. exporting object type definitions for user HR About to export HR's objects .... exporting database links. exporting sequence numbers. exporting cluster definitions. about to export HR's tables via Conventional Path .... . exporting table COUNTRIES 25 rows exported. . exporting table DEPARTMENTS 27 rows exported. . exporting table EMPLOYEES 107 rows exported. . exporting table JOBS 19 rows exported. . exporting table JOB_HISTORY 10 rows exported. . exporting table LOCATIONS 23 rows exported. . exporting table REGIONS 4 rows exported. exporting synonyms. exporting views. exporting stored procedures. exporting operators. exporting referential integrity constraints. exporting triggers. exporting indextypes. exporting bitmap, functional and extensible indexes. exporting posttables actions. exporting materialized views. exporting snapshot logs. exporting job queues. exporting refresh groups and children. exporting dimensions. exporting post-schema procedural objects and actions. exporting statisticsExport terminated successfully without warnings.rac2->