平武建站

10g数据泵导出，12c数据泵导入

10g

专注于为中小企业提供成都网站建设、成都网站设计服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业庄浪免费做网站提供优质的服务。我们立足成都，凝聚了一批互联网行业人才，有力地推动了上千家企业的稳健成长，帮助中小企业通过网站建设实现规模扩充和转变。

1、创建test用户相关信息
create directory dump_dir as '/home/oracle';
grant read,write on directory dump_dir to test;
grant exp_full_database to test;
2、导出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; 没有分配这一项，报错，相关信息如下。

我的导入：
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都一致但是导入还是有中文乱码，经过查询查找，发现源端设置了export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK，目标端没有设置，目标端设置以后，导入没有乱码了。

附录：
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;


网站题目：10g数据泵导出，12c数据泵导入
链接地址：http://pwwzsj.com/article/gshods.html

其他资讯