Month: February 2010
-
IMP-00017: Statement Failed with ORA-02304 During Schema Import
An Oracle schema import can fail when object types are imported back into the same database under a different schema. The log commonly shows IMP-00017 together with ORA-02304: invalid object identifier literal, or the Data Pump wrapper error ORA-39083. Why it happens Oracle object types can have database-wide object identifiers (OIDs). By default, an export…