Database Software

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!

DBMS_DATAPUMP and ORA-02304

ZaboJan 22 2013 — edited Jan 22 2013

Hello,

I'm using Oracle 11gR2.

I'm exporting a database schema (S1) with dbms_datapump.

In S1, I have stored data type (ex : CREATE OR REPLACE TYPE MY_Type IS OBJECT (My_ID NUMBER(11)); )

when I'm importing in the same database my datapump to a new schema S2, I get ORA-02304 exception.

I tried this command dbms_datapump.METADATA_TRANSFORM(handle => dph,name => 'OID',value => 1); But it does not work.

What should I do to correctly import S1 into S2 ?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2013

Added on Jan 22 2013

#database-key-features, #export-import-sql-loader-external-tables

4 comments

406 views