Raf
asked on
Import DataPump error
Hi expert,
my Oracle version is 12.1 and during Oracle import datapump I get the folowing error:
. . imported "SYS"."NACL$_IMP" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_POS T_INSTANCE _IMPCALLOU /MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TAB LE/PROCACT _INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TAB LE/TABLE
ORA-39083: Object type TABLE:"RAD_OWN"."TAB_RAD" failed to create with error:
ORA-01882: timezone region not found
Failing sql is:
CREATE TABLE "RAD_OWN"."TAB_RAD" ("RADAC" NUMBER(*,0) NOT NULL ENABLE, "ACCTSESSI" VARCHAR2(64 BYTE) NOT NULL ENABLE, "ACCTUN" VARCHAR2(32 BYTE), "USERNAME" VARCHAR2(64 BYTE) NOT NULL ENABLE, "GROUPNAME" VARCHAR2(32 BYTE), "REALM" VARCHAR2(30 BYTE), "NASIPADDRESS" VARCHAR2(15 BYTE) NOT NULL ENABLE, "NASPORTID" VARCHAR2(15 BYTE),
ORA-39083: Object type TABLE:"PPB"."TRIP_ERR" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:
CREATE TABLE "PPB"."TRIP_ERR" ("ID" NUMBER(19,0) NOT NULL ENABLE, "VEHICLE_ID" NUMBER(10,0), "MESSAGE_TYPE" VARCHAR2(500 BYTE), "TRIPPOINT_START_TRIGGER" NUMBER(19,0), "TRIPPOINT_STOP_TRIGGER" NUMBER(19,0), "PACKET_ID" NUMBER(19,0), "INSERTTIMESTAMP" DATE NOT NULL ENABLE, "ANALYSYS_RESULT" VARCHAR2(500 BYTE), "ANALYSYS_T
Processing object type DATABASE_EXPORT/SCHEMA/TAB LE/TABLE_D ATA
. . imported "PPUB"."TB_P" 64.19 GB 771212642 rows
How do I fix this error and be able to import the .dmp file successfully?
Thanks in advance!
Regards
my Oracle version is 12.1 and during Oracle import datapump I get the folowing error:
. . imported "SYS"."NACL$_IMP" 0 KB 0 rows
Processing object type DATABASE_EXPORT/NORMAL_POS
Processing object type DATABASE_EXPORT/SCHEMA/TAB
Processing object type DATABASE_EXPORT/SCHEMA/TAB
ORA-39083: Object type TABLE:"RAD_OWN"."TAB_RAD" failed to create with error:
ORA-01882: timezone region not found
Failing sql is:
CREATE TABLE "RAD_OWN"."TAB_RAD" ("RADAC" NUMBER(*,0) NOT NULL ENABLE, "ACCTSESSI" VARCHAR2(64 BYTE) NOT NULL ENABLE, "ACCTUN" VARCHAR2(32 BYTE), "USERNAME" VARCHAR2(64 BYTE) NOT NULL ENABLE, "GROUPNAME" VARCHAR2(32 BYTE), "REALM" VARCHAR2(30 BYTE), "NASIPADDRESS" VARCHAR2(15 BYTE) NOT NULL ENABLE, "NASPORTID" VARCHAR2(15 BYTE),
ORA-39083: Object type TABLE:"PPB"."TRIP_ERR" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:
CREATE TABLE "PPB"."TRIP_ERR" ("ID" NUMBER(19,0) NOT NULL ENABLE, "VEHICLE_ID" NUMBER(10,0), "MESSAGE_TYPE" VARCHAR2(500 BYTE), "TRIPPOINT_START_TRIGGER" NUMBER(19,0), "TRIPPOINT_STOP_TRIGGER" NUMBER(19,0), "PACKET_ID" NUMBER(19,0), "INSERTTIMESTAMP" DATE NOT NULL ENABLE, "ANALYSYS_RESULT" VARCHAR2(500 BYTE), "ANALYSYS_T
Processing object type DATABASE_EXPORT/SCHEMA/TAB
. . imported "PPUB"."TB_P" 64.19 GB 771212642 rows
How do I fix this error and be able to import the .dmp file successfully?
Thanks in advance!
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.