Database Utilities (MOSC)

MOSC Banner

IMPDP fails with ORA-39083: Object type TABLE:"INUSER"."IN_DOC" failed to create with error: ORA-018

edited Jan 12, 2015 2:30PM in Database Utilities (MOSC) 2 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center