Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to resolve create type error?

846231Jul 17 2012 — edited Jul 17 2012

Hi all,

I am duplicating the contents of schema1 to schema2 on the same database.
So I used expdp schema1/schema1 .... exporting schema1. Then impdp schema2/schema2 remap_schema=schema1:schema2

These 2 schemas have dba privilege.

Why do I get this error:

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "C1DEVADM"."CMQTNQHT"   OID 'AC82C504E18C6A98E044001A4B08907C' AS TABLE OF CMQTNQHF;

Thanks a lot,

This post has been answered by Fran on Jul 17 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2012

Added on Jul 17 2012

#general-database-discussions

4 comments

470 views