I have a user
I exported all data stuff and import in my new user stuff
While importing i got the error
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing PAMS's objects into PAMS4NINE
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "T_STRING_AGG" TIMESTAMP '2012-05-11:15:27:23' OID '98013589951"
Please help. Thanks sir
It would be nice to move to Data Pump and not use the older version. The issue is that the OID identifier is already used. You need to import it and tell import to ignore OIDs. I don't know how to do this in the old exp/imp. In Data Pump, you would use this in your impdp command: transform=oid:n
There is a TOID_NOVALIDATE in imp, but I can't remember what it does.