Hi OTN Team,
Import is failing with following error, while importing schema/data from a 12c(12.1.0.2.0) DB User.
Using same version(12.1.0.2.0) of 12c DB client and server for exporting and importing.
OS Level : OEL 7.2
Commands used:
-----------------------
Export: exp $ORACLE_USER_PIN/$ORACLE_USER_PIN@$ORACLE_SID file=pin.dmp as $ORACLE_USER_PIN;
Import: imp $ORACLE_USER_PIN/$ORACLE_USER_PIN@$ORACLE_SID file=pin.dmp ignore=Y full=Y";
Error Log:
-----------
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing PIN811's objects into PIN320
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "POID_ID0_TT" TIMESTAMP '2017-05-31:09:41:36' OID '50D597F7BDD9"
"CFA2E0534658C40A486A' "
"AS"
" TABLE OF INTEGER;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "PIN_EVENT_TY" TIMESTAMP '2017-05-31:10:09:29' OID '50D5FBB7336"
"2D442E0534658C40AC7A0' AS OBJECT (event_name VARCHAR2(32), flist_buf V"
"ARCHAR2(4000), large_flist_buf CLOB) "
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
Any early inputs in this regard are appreciated.
Thanks,
Satya Srikar