oracle 无法导入，数据库字符集是一样的 oracle数据库（PLSQL）导入.sql文件出错：无效的...

oracle\u5bfc\u51fa\u5bfc\u5165\uff0c\u7248\u672c\u4e0d\u540c\u3001\u5b57\u7b26\u96c6\u4e0d\u540c\uff0c\u5e94\u8be5\u600e\u4e48\u64cd\u4f5c\uff0c\u6c42\u5927\u54e5\u5927\u59d0\u4eec\u6307\u70b9\u3002

1\u3001head -5 a.dmp\u53ef\u4ee5\u770b\u5230dmp\u6587\u4ef6\u7248\u672c
\u7248\u672c\u5982\u679c\u4e0d\u517c\u5bb9\uff0c\u4f60\u53ef\u4ee5\u7528sed\u4fee\u6539\u7248\u672c\u53f7
sed -i 's/11.02.01/10.02.01/g' a.dmp
2\u3001\u5b57\u7b26\u7684\u95ee\u9898\uff0c\u4f60\u5728\u5bfc\u51fa\u6570\u636e\u7684\u65f6\u5019\uff0c\u6307\u5b9a\u5b57\u7b26\u96c6\u5c31\u53ef\u4ee5\u4e86
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
\u7136\u540e\u5c31\u53ef\u4ee5\u5c06\u5bfc\u51fa\u7684\u6570\u636e\u5bfc\u5165\u5230\u5b57\u7b26\u96c6\u4e3aZHS16GBK\u6570\u636e\u5e93\u4e2d\u4e86\u3002

\u4fee\u6539oracle\u7684\u5b57\u7b26\u96c6\u5427\u3002

\u547d\u4ee4\u884c\u4e2d\uff1a
sqlplus / as sysdba;//\u6ce8\u610f\u7a7a\u683c
//\u5173\u95ed\u6240\u6709\u8fde\u63a5\u6570\u636e\u5e93\u7684\u8fde\u63a5
SQL>SHUTDOWN IMMEDIATE;

\u3000\u3000\u3000SQL>STARTUP MOUNT;

\u3000\u3000SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

\u3000\u3000SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

\u3000\u3000SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;

\u3000\u3000SQL>ALTER DATABASE OPEN;

\u3000\u3000SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK; \u3000\u3000SQL>SHUTDOWN IMMEDIATE;

\u3000\u3000SQL>STARTUP

\u5b57\u7b26\u96c6\u5c31\u4fee\u6539\u4e86\u3002\u6211\u4f30\u8ba1\u7528\u6c49\u5b57\u7f16\u7801\u80af\u5b9a\u7b26\u5408\u4f60\u7684\u8981\u6c42\uff0c\u53e6\u5916\u4f60\u7684\u6587\u4ef6\u5c31\u7528\u8bb0\u4e8b\u672c\u6253\u5f00\uff0c\u53e6\u5b58\u4e3a\uff0c\u7f16\u7801\u9009\u62e9"ansi"\u5373\u53ef\u3002
\u8865\u5145\u4e00\u70b9\uff0c\u4f60\u770b\u770b\u4f60\u5bfc\u51fa\u7684sql\u5982\u679c\u5b58\u5728?????\u90a3\u5c31\u8bf4\u660e\u6c49\u5b57\u4ec0\u4e48\u7684\u5bfc\u51fa\u540e\u4e22\u5931\u4e86\uff0c\u90a3\u5c31\u6ca1\u6709\u597d\u529e\u6cd5\u4e86\u3002

你这个是目标库里面已经有这个表了PUBTEXT_TMP，跟字符集没关系的。
following statement failed because the object already exists。
你看下目标库这个表是不是有数据，如果没有数据就先把目标库的这个表drop掉，再导

"IMP-00015: following statement failed because the object already exists:
" CREATE TABLE "PUBTEXT_TMP"
.......这句话已经给出了查问题的入手点，创建表PUBTEXT_TMP因为已经存在而失败

扩展阅读：oracle imp导入dmp命令 ... oracle rowid修改数据 ... oracle导入数据库dmp ... oracle无法套接字读取 ... oracle大批量导入数据 ... oracle imp导入改表名 ... oracle sqlldr ... oracle导入csv数据 ... oracle数据泵导入导出整库 ...