Hi
Actullay we have a done exportdump using expdp table level and while import the dump using impdp and different tablespace created tablespace arch_Data and Arch_idx we have face below issues
Import: Release 10.2.0.5.0 - Production on Monday, 12 May, 2014 10:48:37
Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "GSCC"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "GSCC"."SYS_IMPORT_TABLE_01": gscc/******** tables=ARCH_INVOICES,ARCH_INVOICE_ITEMS directory=DUMP_DIR dumpfile=ARCHIVE_INVOICE.dmp logfile=ARCHIVE_INVOICE.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'PROD' does not exist
Failing sql is:
CREATE TABLE "GSCC"."ARCH_INVOICES" ("ID" NUMBER(10,0) NOT NULL ENABLE, "SUB_TYPE" VARCHAR2(4 BYTE) NOT NULL ENABLE, "NBR" NUMBER(8,0), "PREPARED" DATE NOT NULL ENABLE, "SORDER_ID" NUMBER(10,0), "CUST_ID" VARCHAR2(4 BYTE), "TRADE_ID" VARCHAR2(4 BYTE), "CONTR_ID" VARCHAR2(5 BYTE), "SCHV_CARRIER_TYPE" VARCHAR2(4 BYTE), "SCHV_VISITOR" VARCHAR2(10 BYTE), "SCHV_VOYAGE" VARCHAR2(10 BYTE), "SCHV_
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'PROD' does not exist
Failing sql is:
CREATE TABLE "GSCC"."ARCH_INVOICE_ITEMS" ("INVOICE_ID" NUMBER(10,0) NOT NULL ENABLE, "SEQ" NUMBER(4,0) NOT NULL ENABLE, "TITEM_ID" VARCHAR2(5 BYTE), "TITEM_DESCRIPTION" VARCHAR2(100 BYTE), "QTY_PROVIDED" NUMBER(8,3), "QTY_BILLED" NUMBER(12,3), "TRATE_RATE" NUMBER(11,2), "RATE_CHARGED" NUMBER(11,2), "AMOUNT" NUMBER(13,2), "FINAL" VARCHAR2(1 BYTE), "TRATE_GKEY" NUMBER(10,0), "SORDER_ID" NUMB
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"GSCC" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_INVC_PK" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_INVC_CUSTID_FK" skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_IITEM_TITEM_ID" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_IITEM_PK" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_IITEM_EQUSE_FK" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
ORA-39112: Dependent object type INDEX:"GSCC"."ARCH_IITEM_BL_UNIT_ID" skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_INVC_CUSTID_FK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_INVC_PK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_IITEM_BL_UNIT_ID" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_IITEM_EQUSE_FK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_IITEM_PK" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"GSCC"."ARCH_IITEM_TITEM_ID" creation failed
Processing object type TABLE_EXPORT/TABLE/COMMENT
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"GSCC"."ARCH_INVOICES" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"GSCC"."ARCH_INVOICE_ITEMS" creation failed
Job "GSCC"."SYS_IMPORT_TABLE_01" completed with 36 error(s) at 10:48:43