ORA-39083: Object type TABLE

Problem : While importing data in oracle with impdp command, i got the following error
ORA-39083: Object type TABLE:"SECH"."SCH_DISPATCHMSG" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:

CREATE TABLE "SECH"."SCH_DISPATCHMSG" ("PK_MSG" NUMBER NOT NULL ENABLE, "MSG_SENDON" DATE, "MSG_STATUS" NUMBER, "MSG_TYPE" CHAR(2 BYTE), "FK_EVENT" NUMBER, "MSG_TEXT" VARCHAR2(4000 BYTE), "RID" NUMBER, "CREATOR" NUMBER, "LAST_MODIFIED_BY" NUMBER, "LAST_MODIFIED_DATE" DATE, "CREATED_ON" DATE DEFAULT sysdate, "IP_ADD" VARCHAR2(15 BYTE), "FK_PAT" NUMBER, "FK_SCHEVENT" CHAR(10)


Solution : The problem is fixed by adding VERSION option in impdp command as follows

DIRECTORY=<Db_directory>
DUMPFILE=CLNDB9B637.DMP
LOGFILE=<logfile>
VERSION=10.2.0.3



Adding version option solved my problem and original source where i found the solution is this

0 nhận xét:

Đăng nhận xét