This discussion is archived
5 Replies Latest reply: Oct 3, 2012 5:42 AM by 954011 RSS

Importing a EIF file programatically

954011 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points