sql执行提示"?????? "_legacy mode active due to the following parameters-优快云博客

本文详细介绍了在Oracle数据库中进行导出和导入操作的过程，包括如何设置参数、使用命令行工具expdp和impdp，以及如何解决迁移过程中遇到的问题。

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=db_full_backup120208111358" Location: Command Line, Replaced with: "dumpfile=db_full_backup120208111358"
Legacy Mode Parameter: "log=expdp.log" Location: Command Line, Replaced with: "logfile=expdp.log"
Legacy Mode has set reuse_dumpfiles=true parameter.
?? "AIKI"."SYS_EXPORT_SCHEMA_01": aiki/******** directory=aiki_direc dumpfile=db_full_backup120208111358 logfile=expdp.log reuse_dumpfiles=true
???? BLOCKS ??????...
?????? SCHEMA_EXPORT/TABLE/TABLE_DATA
?? BLOCKS ??????: 112.0 MB
?????? SCHEMA_EXPORT/USER
?????? SCHEMA_EXPORT/SYSTEM_GRANT
?????? SCHEMA_EXPORT/ROLE_GRANT
?????? SCHEMA_EXPORT/DEFAULT_ROLE
?????? SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
?????? SCHEMA_EXPORT/TABLE/TABLE
?????? SCHEMA_EXPORT/TABLE/INDEX/INDEX
?????? SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
?????? SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
?????? SCHEMA_EXPORT/TABLE/COMMENT
?????? SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
?????? SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . ??? "AIKI"."SYS_IMPORT_TABLE_01"                42.85 MB   23185 ?
. . ??? "AIKI"."SYS_IMPORT_TABLE_02"                42.85 MB   23185 ?
. . ??? "AIKI"."A"                                  7.100 MB   73368 ?
. . ??? "AIKI"."A2"                                 737.4 KB   10800 ?
. . ??? "AIKI"."TT"                                 5.460 KB       3 ?
. . ??? "AIKI"."T_F"                                5.406 KB       1 ?
?????/????? "AIKI"."SYS_EXPORT_SCHEMA_01"
******************************************************************************
AIKI.SYS_EXPORT_SCHEMA_01 ???????:
/u01/aiki/db_full_backup120208111358.dmp

?? "AIKI"."SYS_EXPORT_SCHEMA_01" ?? 11:14:44 ????

---------------------------------------------------------------------------------------------------

solution:

1.select name,value$ from props$ where name='NLS_CHARACTERSET';

NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK

2.在用户的属性文件(.profile或者.bash_profile具体看你使用哪种shell)

加入:NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG

3:重新连接用户su - user

4:ok