3 Replies Latest reply: Sep 2, 2008 4:11 PM by 656521 RSS

    Data Pump problem

    576939
      SQL*Plus: Release 10.1.0.2.0

      SQL> ALTER USER scott IDENTIFIED BY tiger ACCOUNT UNLOCK;

      User altered.

      SQL> GRANT CREATE ANY DIRECTORY TO scott;

      Grant succeeded.

      SQL> CREATE OR REPLACE DIRECTORY test_dir AS 'c:/';

      Directory created.

      SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO scott;

      Grant succeeded.

      expdp scott/tiger tables=emp,dept directory=test_dir dumpfile=c:/test.dmp logfile=c:/test.log

      ORA-39002: invalid operation
      ORA-39070: unable to open the log file
      ORA-39088: file name cannot contain a path specification

      Where I am making mistake
      thanks & best regards