PROBLEM:

While importing schema objects, got below errors.

ORA-39083: Object type TYPE:"PADADM10-."NAME_AND_COUNT_ARRAY" failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE EDITIONABLE TYPE -PADADM10-."NAME_AND_COUNT_ARRAY" OID -576CD3FFA14D4400E05400144FFFAA04- IS VARRAY(30) OF name_and_count_t;

ROOT CAUSE:

OID value of  TYPE should be unique in the database and So if try to import TYPE with SAME OID, it will fail with this error.

In the above error, the OID is OID -576CD3FFA14D4400E05400144FFFAA04-. So check whether that OID is already present or not.

SQL> select owner,type_oid from dba_types where TYPE_OID='576CD3FFA14D4400E05400144FFFAA04';

OWNER           TYPE_OID
--------------- --------------------------------
TASDB          576CD3FFA14D4400E05400144FFFAA04

As the OID has already existed in the database, so TYPE getting imported should be generated using NEW OID.

SOLUTION:

So the solution to avoid this type of error is to use TRANSFORM=oid:n parameter with impdp.

Impdp command will look as below

impdp dumpfile=TEST_%U.dmp logfile=TEST_imp.log directory=T remap_schema=TEST:TEST10 parallel=4 TRANSFORM=oid:n

This command will import the TYPES with NEW OIDs

impdpORA- TROUBLESHOOTING


Related Topics

TNS-01106: Listener using listener name has already been started
ORA-01536: space quota exceeded for tablespace
ORA-32771: cannot add file to bigfile tablespace
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
ORA-32773: operation not supported for smallfile tablespace
TNS-12542: TNS:address already in use
ORA-32774: more than one file was specified for bigfile tablespace
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
ORA-16855: transport lag has exceeded specified threshold

You May Also Like

How to generate ADDM report
Add database as target oracle 12c cloud control
How to find execution history of an sql_id
How to drop a database in postgres
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
oraversion utility in oracle 18c - New feature
How to create encrypted tablespace in PDB( oracle 12c)
ERROR: permission denied for schema in postgres
Find user commits per minute in oracle database
Blackout targets in OEM 12c cloud control

From This Website

ORA-32771: cannot add file to bigfile tablespace
How to flashback a Pluggable database ( PDB) in oracle 12.2
Hive Installation with derby
Useful DGMGRL commands in oracle dataguard
ENABLE_DDL_LOGGING in oracle 12c
sec_case_sensitive_logon parameter in oracle
_use_adaptive_log_file_sync parameter in oracle
ERROR: permission denied for schema in postgres
Shell script to report failed login attempt in oracle
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only