5 Replies Latest reply: Oct 3, 2012 7:42 AM by 954011 RSS

    Importing a EIF file programatically

    954011
      I am new to DML.
      How should I import the EIF file using sql script.
      Please let me know the sequence of steps that needs to be done.
      In one box, I exported to EIF, and the file got created in /opt/oracle/base/admin/cpcm/dpdump

      In another box, I placed this EIF file in the same dir, and ran this :

      SQL> EXECUTE DBMS_AW.AW_ATTACH('global', TRUE, TRUE);
      PL/SQL procedure successfully completed
      SQL> execute DBMS_AW.AW_EXECUTE('IMPORT ALL TO EIF FILE ','importeif.sql');
      BEGIN DBMS_AW.AW_EXECUTE('IMPORT ALL TO EIF FILE ','importeif.sql'); END;

      *
      ERROR at line 1:
      ORA-06550: line 1, column 15:
      PLS-00302: component 'AW_EXECUTE' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      Please help.