Hi,experts
Show error ORA-39112 when impdp data using data pump.
My source DB environment:
DB version: Oracle 11.2.0.4.0 Data Guard primary for Linux x64 Characterset: AMERICAN_AMERICA.AL32UTF8
and target DB environment:
DB version: Oracle 11.2.0.4.0 RAC for Linux x64 Characterset: AMERICAN_AMERICA.ZHS16GBK
Now,my operating process is as follows,
[oracle@oracdg1 ~]$ impdp system/oracle directory=impdp dumpfile=base_school_20171107.dmp logfile=impdp_base_school_20171109.log tables=szd_base_v2.base_school remap_schema=szd_base_v2:base remap_tablespace=szd_base_v2:base,mis_base:base1,szd_base_v2_temp:base_temp statistics=none indexes=y
Import: Release 11.2.0.4.0 - Production on Thu Nov 9 10:36:15 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "indexes=TRUE" Location: Command Line, ignored.
Legacy Mode Parameter: "statistics=none" Location: Command Line, ignored.
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** directory=impdp dumpfile=base_school_20171107.dmp logfile=impdp_base_school_20171109.log tables=szd_base_v2.base_school remap_schema=szd_base_v2:base remap_tablespace=szd_base_v2:base,mis_base:base1,szd_base_v2_temp:base_temp
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"BASE"."BASE_SCHOOL" failed to create with error:
ORA-01918: user 'BASE' does not exist
Failing sql is:
CREATE TABLE "BASE"."BASE_SCHOOL" ("SCHOOL_ID" VARCHAR2(40 BYTE) NOT NULL ENABLE, "AREA_ID" VARCHAR2(40 BYTE), "SCHOOL_NAME" VARCHAR2(200 BYTE), "SCHOOL_TYPE" VARCHAR2(200 BYTE), "PRIMARY_STUDENT_NUM" NUMBER(38,0), "PRIMARY_TEACHER_NUM" NUMBER(38,0), "PRIMARY_CLASS_NUM" NUMBER(38,0), "JUNIOR_STUDENT_NUM" NUMBER(38,0), "JUNIOR_TEACHER_NUM" NUMBER(38,0), "JUNIOR_CLASS_NUM" NUMBE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"BASE"."IDX_REPORTCN_BAOMINCN" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_REPORT_CNT" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_SK_TEACHER_CNT" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_CITY_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_COUNTY_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_AREA_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."PRI_BASE_SCHOOL_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39112: Dependent object type CONSTRAINT:"BASE"."PRI_BASE_SCHOOL_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_REPORTCN_BAOMINCN" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."PRI_BASE_SCHOOL_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_AREA_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_COUNTY_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_CITY_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_SK_TEACHER_CNT" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_REPORT_CNT" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_SCHOOL_TYPE" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_PROVINCE_ID" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_IS_INI" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
ORA-39112: Dependent object type INDEX:"BASE"."IDX_BASE_DELETE_FLAG" skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_DELETE_FLAG" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_IS_INI" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_PROVINCE_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"BASE"."IDX_BASE_SCHOOL_TYPE" creation failed
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"BASE"."BASE_SCHOOL" creation failed
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 25 error(s) at Thu Nov 9 10:36:28 2017 elapsed 0 00:00:09
Therefore,i check error about ORA-39112,
[oracle@oracdg1 ~]$ oerr ora 39112
39112,00000, "Dependent object type %s skipped, base object type %s creation failed"
// *Cause: During a Data Pump import job, a dependent object is being skipped
// because its base object creation failed.
// *Action: If the object from the dump file is wanted, drop the base and
// dependent objects and try to import again using desired filters
Please guide you for solving this issue,thanks a lot!
Best Regards,
Quanwen Zhao