10g 數(shù)據(jù)泵導(dǎo)出，12c數(shù)據(jù)泵導(dǎo)入

10g

1、創(chuàng)建test用戶相關(guān)信息
create directory dump_dir as '/home/oracle';
grant read,write on directory dump_dir to test;
grant exp_full_database to test;
2、導(dǎo)出test下面的相關(guān)信息
expdp test/test dumpfile=t.dmp

12c
create user test identified by test;
grant connect, resource to test;
grant exp_full_database to test;
grant imp_full_database to test;
GRANT UNLIMITED TABLESPACE TO test; 沒有分配這一項，報錯，相關(guān)信息如下。

我的導(dǎo)入：
impdp test/test directory=dump_dir dumpfile=t.dmp ;

Import: Release 12.1.0.2.0 - Production on Mon Apr 22 16:34:54 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "TEST.SYS_IMPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-01950: no privileges on tablespace 'USERS'

sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 22 16:37:56 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> GRANT UNLIMITED TABLESPACE TO test;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
impdp test/test directory=dump_dir dumpfile=t.dmp ;

Import: Release 12.1.0.2.0 - Production on Mon Apr 22 16:38:14 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Master table "TEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TEST"."SYS_IMPORT_FULL_01": test/**** directory=dump_dir dumpfile=t.dmp
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"TEST" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "TEST"."TEST" 5.554 KB 24 rows
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Job "TEST"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Mon Apr 22 16:38:33 2019 elapsed 0 00:00:14

字符集問題：

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

select userenv('language') from dual;和新echo $LANG都一致但是導(dǎo)入還是有中文亂碼，經(jīng)過查詢查找，發(fā)現(xiàn)源端設(shè)置了export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK，目標(biāo)端沒有設(shè)置，目標(biāo)端設(shè)置以后，導(dǎo)入沒有亂碼了。

附錄：
create user test identified by test;
grant connect, resource to test;
grant exp_full_database to test;
grant imp_full_database to test;
create directory dump_dir as '/home/oracle';
grant read,write on directory dump_dir to test;
GRANT UNLIMITED TABLESPACE TO test;