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

    DBMS_DATAPUMP and ORA-02304


      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 ?