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!

datapump import error

Rabi786Jan 3 2012 — edited Sep 24 2013

Hi

I am using oracle 10g R2 10.2.0.3 . While importing an schema i got the following error

ORA-39083: Object type TABLE failed to create with error:
ORA-00907: missing right parenthesis
Failing sql is:
CREATE TABLE "CARDPRO"."CP_VSIMMX" ("VX_SEQ_NO" NUMBER(6,0) NOT NULL ENABLE, "VX_TRXN_CD" NUMBER(2,0), "VX_SRC_BIN" NUMBER(6,0), "VX_DEST_
BIN" NUMBER(6,0), "VX_PROC_YDDD" NUMBER(4,0), "VX_TRXN_DATE" NUMBER(4,0), "VX_CARDHOLDER_NO" CHAR(19), "VX_PRODUCT_CD" NUMBER(4,0), "VX_EX
PIRY_DATE" NUMBER(4,0), "VX_ACQUIRER_REFNO" CHAR(23), "VX_AUTHORZ_CD" CHAR(6), "VX_USAGE_CD" CHAR(1), "VX_TRXN_CURR_AMT" NU
ORA-39083: Object type TABLE failed to create with error:
ORA-00907: missing right parenthesis
Failing sql is:
CREATE TABLE "CARDPRO"."CP_VSLCTX" ("VL_SEQ_NO" NUMBER(6,0) NOT NULL ENABLE, "VL_TRXN_CD" NUMBER(2,0), "VL_SRC_BIN" NUMBER(6,0), "VL_DEST_
BIN" NUMBER(6,0), "VL_PROC_YDDD" NUMBER(3,0), "VL_TRXN_DATE" NUMBER(4,0), "VL_CARDHDR_NO" CHAR(19), "VL_PRODUCT_CD" NUMBER(4,0), "VL_EXPIR
Y_DATE" NUMBER(4,0), "VL_ACQUIRER_REFNO" CHAR(23), "VL_AUTHORZ_CD" CHAR(6), "VL_USAGE_CD" CHAR(1), "VL_TRXN_CURR_AMT" NUMBE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent object type OBJECT_GRANT:"CARDPRO" skipped, base object type TABLE:"CARDPRO"."CP_VSIMMX" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"CARDPRO" skipped, base object type TABLE:"CARDPRO"."CP_VSLCTX" creation failed
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39112: Dependent object type INDEX:"CARDPRO"."PKCP_VSIMMX" skipped, base object type TABLE:"CARDPRO"."CP_VSIMMX" creation failed
ORA-39112: Dependent object type INDEX:"CARDPRO"."CP_VSIMMX" skipped, base object type TABLE:"CARDPRO"."CP_VSIMMX" creation failed
ORA-39112: Dependent object type INDEX:"CARDPRO"."PKCP_VSLCTX" skipped, base object type TABLE:"CARDPRO"."CP_VSLCTX" creation failed
ORA-39112: Dependent object type INDEX:"CARDPRO"."CP_VSLCTX" skipped, base object type TABLE:"CARDPRO"."CP_VSLCTX" creation failed
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"CARDPRO"."PKCP_VSIMMX" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"CARDPRO"."CP_VSIMMX" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"CARDPRO"."PKCP_VSLCTX" creation failed
ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDEX:"CARDPRO"."CP_VSLCTX" creation failed
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"CARDPRO"."CP_VSIMMX" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"CARDPRO"."CP_VSLCTX" creation failed

I have tried myself to find out the reason but didn't find anything. Can you please share me your idea to find out the reason

Regards

Jav

Edited by: user623166 on Jan 2, 2012 10:21 PM