Troubleshooting

When importing (impdp) an Oracle dump file for a Oracle Data Relationship Management Analytics schema to an Oracle database instance where another Data Relationship Management Analytics schema already exists, the following error may occur:

Example 5-1 Error

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is: CREATE TYPE "<schemaName>"."FILTERVALUES_TABLE_TYPE"  OID 'BD565ED4E40844C69873A972C29FE5A9' as TABLE of varchar2 (255)

The error occurs if the dump file includes the Data Relationship Management Analytics 'TYPE' object with a specific Oracle identifier (OID). As a result of the error condition, the imported Data Relationship Management Analytics schema will not function properly.

Workaround

To resolve the error during import, include parameter/value "TRANSFORM=oid:n" in the Data Pump Import command or script. Refer to Oracle Database documentation for details on the Data Pump Import TRANSFORM parameter.