ITPub博客

首页 > 数据库 > Oracle > expdp 全库导入报错总结

expdp 全库导入报错总结

Oracle 作者:urgel_babay 时间:2016-02-29 17:28:05 0 删除 编辑
  2014.11.27

环境:11.2.0.3 64位
impdp \'/ as sysdba\' directory=imp27 full=y dumpfile=full_%U.dmp logfile=fullimp.log parallel=10  table_exists_action=replace;
    由于开发的需要,做了一次正式库全库导出,在倒入到测试库。结果出现一些报错:
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
ORA-31684: Object type TABLESPACE:"TBS_SD_BL" already exists

ORA-39083: Object type TABLESPACE failed to create with error:
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
Failing sql is:
CREATE TABLESPACE "TBS_VIEW_BL" DATAFILE '/u04/datafile/TBS_VIEW_BL01.dbf' SIZE 8589934592 AUTOEXTEND ON NEXT 10485760 M
AXSIZE 5120M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SP
ACE MANAGEMENT AUTO

Failing sql is:
 ALTER USER "SYS" IDENTIFIED BY VALUES 'S:F911CF680FFB1D8DCB017DCCF55D4D464F72B7D45C6CB3E85092DC58D601;CA908C0E625F4F62'
 TEMPORARY TABLESPACE "TEMP2"
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-39083: Object type USER failed to create with error:
ORA-00959: tablespace 'TEMP2' does not exist
Failing sql is:
 ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'S:D8DC00054068D35077EA3B307F27DEA44708DF6F14FB8E364CF2B81F164E;2D594E86F93B17
A1' TEMPORARY TABLESPACE "TEMP2"


ORA-31684: Object type USER:"SYSMAN" already exists
ORA-31684: Object type USER:"MGMT_VIEW" already exists

ORA-31684: Object type ROLE:"SELECT_CATALOG_ROLE" already exists
ORA-31684: Object type ROLE:"EXECUTE_CATALOG_ROLE" already exists

ORA-31684: Object type DB_LINK:"U_CL_CTL"."ZZHD195" already exists

ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS_S" already exists
ORA-31684: Object type SEQUENCE:"SYSTEM"."REPCAT$_TEMPLATE_OBJECTS_S" already exists

ORA-39111: Dependent object type OBJECT_GRANT:"OLAPSYS" skipped, base object type SEQUENCE:"OLAPSYS"."CWM2_OLAP_ENABLESE
Q" already exists

ORA-31684: Object type DIRECTORY:"DATA_PUMP_DIR" already exists
ORA-31684: Object type DIRECTORY:"XMLDIR" already exists

ORA-31684: Object type CONTEXT:"EM_USER_CONTEXT" already exists
ORA-31684: Object type CONTEXT:"STORAGE_CONTEXT" already exists
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$" already exists
ORA-31684: Object type SYNONYM:"PUBLIC"."OL$HINTS" already exist

ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
 SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ZBSHOES','x86_64/Linux 2.4.xx');
 END;

上面的报错信息,都是安装倒入日志的的先后顺序,
1、在做全库倒入的时候,要先把相应的表空间建上,不然可能由于路径的原因报错,上面的有创建TBS_VIEW_BL 表空间失败。
2、全库倒入的时候,不需要建立用户,但是我试验的情况,建上也没关系,最多提示用户已存在,其实这个报错可以忽略。
3、全库倒入的时候,会一次检查,用户,角色,视图,DIRECTORY,存储过程,权限,同义词... 最后一步就是insert表数据。



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30936525/viewspace-2016688/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-02-29

  • 博文量
    203
  • 访问量
    215097