Data Relationship Management Analytics
Issue:
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:
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.
Solution:
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.