sql执行提示"?????? "

最新推荐文章于 2023-10-16 22:15:00 发布

最新推荐文章于 2023-10-16 22:15:00 发布 · 191 阅读

文章标签：

本文详细介绍了如何通过Oracle数据库的导出与导入功能进行数据迁移，并解决导出过程中遇到的NLS_CHARACTERSET设置问题。通过调整用户属性文件中的NLS_LANG参数，确保数据正确迁移。

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