Link to home
Start Free TrialLog in
Avatar of Raf
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_POST_INSTANCE_IMPCALLOU/MARKER
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/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/TABLE/TABLE_DATA
. . 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
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial