4 Replies Latest reply: Jan 22, 2013 4:39 AM by Fran RSS

    DBMS_DATAPUMP and ORA-02304

    Zabo
      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.