10g data pump export, 12c data pump import
10g
1. Create test user related information
Create directory dump_dir as'/ home/oracle'
Grant read,write on directory dump_dir to test
Grant exp_full_database to test
2. Export the relevant information under test
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; did not assign this item and reported an error. The relevant information is as follows.
My import:
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
Character set problem:
Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
Select userenv ('language') from dual; and the new echo $LANG are the same, but there are still Chinese garbled in the import. After query and search, it is found that export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK is set in the source side, but not in the destination side. After the destination side is set, there is no garbled code in the import.
Appendix:
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
