1 Reply Latest reply on Dec 4, 2019 1:55 PM by Dean Gagne-Oracle

    import error

    s k swain

      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"

      "F4657804A5E9345A44175' 

       

      Please help. Thanks sir

        • 1. Re: import error
          Dean Gagne-Oracle

          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.

           

          Dean