0 Replies Latest reply: Oct 1, 2012 8:21 AM by 965393 RSS

    Issues when Importing a EIF file from sql * plus

    965393
      Hi All,

      I am trying to import .eif file from sql * plus by using following commands and got some issues. Can anyone help me on this(I got this queries in this forum only. )



      SQL>
      execute DBMS_AW.EXECUTE('IMPORT ALL FROM EIF FILE ''eif_dir/xyz''');
      ERROR:
      ORA-01756: quoted string not properly terminated


      SQL>
      execute DBMS_AW.EXECUTE(q'! IMPORT ALL FROM EIF FILE 'eif_dir/xyz.eif' !');
      ERROR:
      ORA-01756: quoted string not properly terminated


      Thanks in advance.