Importing a EIF file programatically
954011Sep 14 2012 — edited Oct 3 2012I 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.