Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12C Database Full Import on RAC

RamarajuJun 30 2016 — edited Jul 7 2016

Hi,

We are importing 12c full database. While importing we are getting following errors.

DB: 12.1.0.2.0

RAC

No CDB & PDBS.

Could you please help me on these issues. We need fix these issues ASAP. Please help.

Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA directory=expdp dumpfile=export_CINE01PR_full_08062016_%U.dmp logfile=import_CINE01PR_full_08062016.log full=y

Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER

Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER

Processing object type DATABASE_EXPORT/TABLESPACE

ORA-39083: Object type TABLESPACE:"EXAMPLE" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/example.304.906661177"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/example.304.906661177' RESIZE 222298112

ORA-31684: Object type TABLESPACE:"TEMP" already exists

ORA-39083: Object type TABLESPACE:"CWMLITE" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/cwmlite.307.906661029"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/cwmlite.307.906661029' RESIZE 79691776

ORA-31684: Object type TABLESPACE:"PERFSTAT" already exists

ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists

ORA-39083: Object type TABLESPACE:"ODM" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/odm.302.906661179"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/odm.302.906661179' RESIZE 80740352

ORA-39083: Object type TABLESPACE:"ECINESYS" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/ecinesys.305.906661031"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/ecinesys.305.906661031' RESIZE 108632473600

ORA-39083: Object type TABLESPACE:"DRSYS" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/drsys.306.906661029"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/drsys.306.906661029' RESIZE 75497472

ORA-31684: Object type TABLESPACE:"USERS" already exists

ORA-39083: Object type TABLESPACE:"QUEST" failed to create with error:

ORA-01516: nonexistent log file, data file, or temporary file "+DATA/CINE01PR/DATAFILE/quest.300.906661185"

Failing sql is:

ALTER DATABASE DATAFILE '+DATA/CINE01PR/DATAFILE/quest.300.906661185' RESIZE 165675008

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$DATABASE_INSTANCE" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$DB_CACHE_ADVICE" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$SNAPSHOT_ID" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$SNAPSHOT" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$LEVEL_DESCRIPTION" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$FILESTATXS" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$LATCH" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$TEMPSTATXS" already exists

ORA-31684: Object type SYNONYM:"PUBLIC"."STATS$LATCH_PARENT" already exists

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

ORA-39083: Object type TABLE:"SH"."COSTS" failed to create with error:

ORA-00439: feature not enabled: Partitioning

Failing sql is:

CREATE TABLE "SH"."COSTS" ("PROD_ID" NUMBER(6,0) CONSTRAINT "COSTS_PRODUCT_NN" NOT NULL ENABLE, "TIME_ID" DATE CONSTRAINT "COSTS_TIME_NN" NOT NULL ENABLE, "UNIT_COST" NUMBER(10,2) CONSTRAINT "COSTS_UNIT_COST_NN" NOT NULL ENABLE, "UNIT_PRICE" NUMBER(10,2) CONSTRAINT "COSTS_UNIT_PRICE_NN" NOT NULL ENABLE) PCTFREE 5 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOLOGGING STORAGE( BUFFER_PO

ORA-39083: Object type TABLE:"SH"."SALES" failed to create with error:

ORA-00439: feature not enabled: Partitioning

Failing sql is:

CREATE TABLE "SH"."SALES" ("PROD_ID" NUMBER(6,0) CONSTRAINT "SALES_PRODUCT_NN" NOT NULL ENABLE, "CUST_ID" NUMBER CONSTRAINT "SALES_CUSTOMER_NN" NOT NULL ENABLE, "TIME_ID" DATE CONSTRAINT "SALES_TIME_NN" NOT NULL ENABLE, "CHANNEL_ID" CHAR(1 BYTE) CONSTRAINT "SALES_CHANNEL_NN" NOT NULL ENABLE, "PROMO_ID" NUMBER(6,0) CONSTRAINT "SALES_PROMO_NN" NOT NULL ENABLE, "QUANTITY_SOLD" NUM

ORA-39151: Table "SCOTT"."BONUS" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "SCOTT"."DEPT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "SCOTT"."EMP" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "SCOTT"."SALGRADE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39083: Object type TABLE:"CINESYS_READ"."TEST1" failed to create with error:

ORA-01950: no privileges on tablespace 'SYSTEM'

Failing sql is:

CREATE TABLE "CINESYS_READ"."TEST1" ("COL1" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE( INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM"

ORA-39151: Table "PERFSTAT"."STATS$PARAMETER" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$PGASTAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$PGA_TARGET_ADVICE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$RESOURCE_LIMIT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$ROLLSTAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$ROWCACHE_SUMMARY" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SEG_STAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SEG_STAT_OBJ" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SESSION_EVENT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SESSTAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SGA" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

ORA-39151: Table "PERFSTAT"."STATS$SGASTAT" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX

ORA-39112: Dependent object type INDEX:"PERFSTAT"."STATS$BG_EVENT_SUMMARY_PK" skipped, base object type TABLE:"PERFSTAT"."STATS$BG_EVENT_SUMMARY" creation failed

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."COSTS_PRODUCT_FK" skipped, base object type TABLE:"SH"."COSTS" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."COSTS_TIME_FK" skipped, base object type TABLE:"SH"."COSTS" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."SALES_PRODUCT_FK" skipped, base object type TABLE:"SH"."SALES" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."SALES_CUSTOMER_FK" skipped, base object type TABLE:"SH"."SALES" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."SALES_TIME_FK" skipped, base object type TABLE:"SH"."SALES" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."SALES_CHANNEL_FK" skipped, base object type TABLE:"SH"."SALES" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"SH"."SALES_PROMO_FK" skipped, base object type TABLE:"SH"."SALES" creation failed

ORA-39112: Dependent object type REF_CONSTRAINT:"PERFSTAT"."STATS$BG_EVENT_SUMMARY_FK" skipped, base object type TABLE:"PERFSTAT"."STATS$BG_EVENT_SUMMARY" creation failed

ORA-39083: Object type REF_CONSTRAINT:"PERFSTAT"."STATS$ENQUEUE_STAT_FK" failed to create with error:

ORA-02298: cannot validate (PERFSTAT.STATS$ENQUEUE_STAT_FK) - parent keys not found

Failing sql is:

ALTER TABLE "PERFSTAT"."STATS$ENQUEUE_STAT" ADD CONSTRAINT "STATS$ENQUEUE_STAT_FK" FOREIGN KEY ("SNAP_ID", "DBID", "INSTANCE_NUMBER") REFERENCES "PERFSTAT"."STATS$SNAPSHOT" ("SNAP_ID", "DBID", "INSTANCE_NUMBER") ON DELETE CASCADE ENABLE

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX

ORA-39112: Dependent object type INDEX:"SH"."COSTS_TIME_BIX" skipped, base object type TABLE:"SH"."COSTS" creation failed

ORA-39112: Dependent object type INDEX:"SH"."COSTS_PROD_BIX" skipped, base object type TABLE:"SH"."COSTS" creation failed

ORA-39083: Object type INDEX:"SH"."CUSTOMERS_YOB_BIX" failed to create with error:

ORA-00439: feature not enabled: Bit-mapped indexes

Failing sql is:

CREATE BITMAP INDEX "SH"."CUSTOMERS_YOB_BIX" ON "SH"."CUSTOMERS" ("CUST_YEAR_OF_BIRTH") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "EXAMPLE" PARALLEL 1

ORA-39083: Object type INDEX:"SH"."CUSTOMERS_MARITAL_BIX" failed to create with error:

ORA-00439: feature not enabled: Bit-mapped indexes

Failing sql is:

CREATE BITMAP INDEX "SH"."CUSTOMERS_MARITAL_BIX" ON "SH"."CUSTOMERS" ("CUST_MARITAL_STATUS") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "EXAMPLE" PARALLEL 1

ORA-39083: Object type INDEX:"SH"."CUSTOMERS_GENDER_BIX" failed to create with error:

ORA-00439: feature not enabled: Bit-mapped indexes

Failing sql is:

CREATE BITMAP INDEX "SH"."CUSTOMERS_GENDER_BIX" ON "SH"."CUSTOMERS" ("CUST_GENDER") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "EXAMPLE" PARALLEL 1

ORA-39083: Object type INDEX:"SH"."FW_PSC_S_MV_WD_BIX" failed to create with error:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER

ORA-31684: Object type TRIGGER:"GUNJAN"."DR$IDX_CTXCAT_MVNAMETC" already exists

ORA-31684: Object type TRIGGER:"GUNJAN"."DR$IDX_CTXCAT_MVNAME1TC" already exists

ORA-31684: Object type TRIGGER:"ORACLE"."DR$C4_PERSON_NAMETC" already exists

ORA-31684: Object type TRIGGER:"ORACLE"."DR$CS_ACTOR_ALTNAMECS_TEXTTC" already exists

ORA-31684: Object type TRIGGER:"ORACLE"."DR$CS_MVID_MVNAME_TEXTTC" already exists

ORA-31684: Object type TRIGGER:"ORACLE"."DR$CS_MVID_MVNAME1_TEXTTC" already exists

Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW

ORA-39083: Object type MATERIALIZED_VIEW:"SH"."CAL_MONTH_SALES_MV" failed to create with error:

ORA-00439: feature not enabled: Materialized view rewrite

Failing sql is:

CREATE MATERIALIZED VIEW "SH"."CAL_MONTH_SALES_MV" ("CALENDAR_MONTH_DESC", "DOLLARS") USING ("CAL_MONTH_SALES_MV", (10, 'CINE01PR', 2, 0, 0, "SH", "TIMES", '2002-05-12 16:33:09', 8, 117612, '2016-04-16 23:21:42', '', 1, '0204', 0, 0, NULL, 1, "SH", "SALES", '2002-05-12 16:33:09', 264, 117594, '2016-04-16 23:21:42', '', 1, '88', 0, 0, NULL),

ORA-39083: Object type MATERIALIZED_VIEW:"SH"."FWEEK_PSCAT_SALES_MV" failed to create with error:

ORA-00439: feature not enabled: Materialized view rewrite

Failing sql is:

CREATE MATERIALIZED VIEW "SH"."FWEEK_PSCAT_SALES_MV" ("WEEK_ENDING_DAY", "PROD_SUBCATEGORY", "DOLLARS", "CHANNEL_ID", "PROMO_ID") USING ("FWEEK_PSCAT_SALES_MV", (10, 'CINE01PR', 3, 0, 0, "SH", "PRODUCTS", '2002-05-12 16:33:19', 8, 117587, '2016-04-16 23:21:42', '', 1, '12', 0, 0, NULL, 1, "SH", "TIMES", '2002-05-12 16:33:19', 8, 117612, '

Processing object type DATABASE_EXPORT/SCHEMA/JOB

Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION

ORA-39083: Object type DIMENSION:"SH"."CUSTOMERS_DIM" failed to create with error:

ORA-00439: feature not enabled: Materialized view rewrite

Failing sql is:

CREATE DIMENSION "SH"."CUSTOMERS_DIM" LEVEL "CUSTOMER" IS ("CUSTOMERS"."CUST_ID") LEVEL "CITY" IS ("CUSTOMERS"."CUST_CITY") LEVEL "STATE" IS ("CUSTOMERS"."CUST_STATE_PROVINCE") LEVEL "COUNTRY" IS ("COUNTRIES"."COUNTRY_ID") LEVEL "SUBREGION" IS ("COUNTRIES"."COUNTRY_SUBREGION") LEVEL "REGION" IS ("COUNTRIES"."COUNTRY_REGION") LEVEL "GEOG_TOTAL" IS ("COU

ORA-39083: Object type DIMENSION:"SH"."PRODUCTS_DIM" failed to create with error:

ORA-00439: feature not enabled: Materialized view rewrite

Failing sql is:

CREATE DIMENSION "SH"."PRODUCTS_DIM" LEVEL "PRODUCT" IS ("PRODUCTS"."PROD_ID") LEVEL "SUBCATEGORY" IS ("PRODUCTS"."PROD_SUBCATEGORY") LEVEL "CATEGORY" IS ("PRODUCTS"."PROD_CATEGORY") LEVEL "PROD_TOTAL" IS ("PRODUCTS"."PROD_TOTAL") HIERARCHY "PROD_ROLLUP" ("PRODUCT" CHILD OF "SUBCATEGORY" CHILD OF "CATEGORY" CHILD OF "PROD_TOTAL") ATTRIBUTE "PRODUCT" LEV

ORA-39083: Object type DIMENSION:"SH"."PROMOTIONS_DIM" failed to create with error:

ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" failed to create with error:

ORA-27477: "APEX_040200"."ORACLE_APEX_PURGE_SESSIONS" already exists

Failing sql is:

BEGIN

dbms_scheduler.create_job('"ORACLE_APEX_PURGE_SESSIONS"',

job_type=>'STORED_PROCEDURE', job_action=>

'WWV_FLOW_CACHE.PURGE_SESSIONS'

, number_of_arguments=>0,

start_date=>TO_TIMESTAMP_TZ('08-JUL-2014 10.10.19.860762000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>

'FREQ

ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_MAIL_QUEUE" failed to create with error:

ORA-27477: "APEX_040200"."ORACLE_APEX_MAIL_QUEUE" already exists

Failing sql is:

BEGIN

dbms_scheduler.create_job('"ORACLE_APEX_MAIL_QUEUE"',

job_type=>'STORED_PROCEDURE', job_action=>

'WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE'

, number_of_arguments=>0,

start_date=>TO_TIMESTAMP_TZ('08-JUL-2014 10.10.20.187179000 AM -07:00','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=>

'FREQ=MINUTE

ORA-39083: Object type PROCOBJ:"APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" failed to create with error:

ORA-27477: "APEX_040200"."ORACLE_APEX_WS_NOTIFICATIONS" already exists

Failing sql is:

BEGIN

dbms_scheduler.create_job('"ORACLE_APEX_WS_NOTIFICATIONS"',

Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER

ORA-39082: Object type FUNCTION:"WKSYS"."WK$IS_ADMIN" created with compilation warnings

ORA-39082: Object type FUNCTION:"WKSYS"."WK$USERID" created with compilation warnings

ORA-39082: Object type PROCEDURE:"WKSYS"."WK$POST_OPTIMIZE_INDEX" created with compilation warnings

ORA-39082: Object type PROCEDURE:"WKSYS"."WK$PRE_OPTIMIZE_INDEX" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."DELETE_WIKIPEDIA" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."DT_SETPROPERTYBYID" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."P360_EFFECTIVENESS_INDEX" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."SP_CURRENTCONNECTIONS" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."STPTOCINESYS_PARENTSOFDATA" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."STPTOCINESYS_PAROFDATA_TEST" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."TEST100" created with compilation warnings

ORA-39082: Object type PROCEDURE:"ORACLE"."USP_WIKIPEDIASUSPECTDAY" created with compilation warnings