Oracle Database Discussions

Hi

My database is oracle 10g 10.2.0.1.0 - 64bit in Solaris. I am trying to import schema /table from my production database to test database using impdp.

expdp is done successfully without any error but when i m running impdp then all schema object import except 2 tables.

error is as under :

Processing object type TABLE_EXPORT/TABLE/TABLE
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_EXPIRY_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_EXPIRY_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 TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_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 TABLE_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 TABLE_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 TABLE_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
Job "CARDPRO"."SYS_IMPORT_FULL_01" completed with 14 error(s) at 12:55:36


please guide me regarding the above error


Regards

rabi