IMPDP fails with ORA-39083: Object type TABLE:"INUSER"."IN_DOC" failed to create with error: ORA-018
Export and import fails with error - all table that has TIMESTAMP column fails to import
ORA-39083: Object type TABLE:"INUSER"."IN_LOCK" failed to create with error:
ORA-01843: not a valid month
SQL to create table
CREATE TABLE "INUSER"."IN_LOCK" ( "LOCK_ID" VARCHAR2(23 BYTE) NOT NULL ENABLE, "LOCKING_USR_ID" VARCHAR2(23 BYTE) NOT NULL ENABLE, "LOCKING_THREAD_ID" NUMBER(12,0) NOT NULL ENABLE, "OBJ_TYPE" NUMBER(12,0) NOT NULL ENABLE, "LOCK_TYPE" VARCHAR2(40 BYTE) NOT NULL ENABLE, "LICENSE_TYPE" NUMBER(12,0) NOT NULL ENABLE, "OBJ_DATA" VARCHAR2(512 BYTE) NOT NULL ENABLE, "IS_MODIFIED" NUMBER(12,0) DEFAULT 0 NOT NULL ENABLE, "LOCK_TIME" TIMESTAMP (6) DEFAULT '1970-01-01 00:00:00' NOT NULL ENABLE, "REF_COUNT" NUMBER(12,0) DEFAULT 0 NOT NULL ENABLE;
2