Data is stored somewhere

IMP-00017: following statement failed with ORACLE error 2304

nnnnnOracle import fails when importing into the same database but to a different schema, with this error. Problem is the type is exported with its object id (OID) in it’s definition. When oracle tries to recreate it in a different schema it fails because OID is unique database wide. Here are the solutions.
n
nOn oracle 8i when using fromuser/touser, see the following
n
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1323002416801
n
nOn oracle 10.1 when using REMAP_SCHEMA
n
Create the types and tables dependent on those type and then use the option TABLE_EXISTS_ACTION=append on impdp
n
nOn oracle 10.2
when using REMAP_SCHEMA
nuse option
TRANSFORM=oid:n on impdp
n
nhere are the metalink notes:
n
Note: 351519.1 Import of Object Types Fails With ORA-39083 ORA-02304 or ORA-39117 ORA-39779
nNote: 1066139.6 “IMP-17 IMP-3 ORA-2304 IMP-63 FROMUSER/TOUSER Import of Table With Object Column”
nNote :1066139.6 – IMP-17 IMP-3 ORA-2304 IMP-63 FROMUSER/TOUSER Import of Table With Object Column
n


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *