Hi all,
Good Day To You...
I'm facing some issues while trying to export oracle using datapump.
1. Create Directory command successfully executes but I'm unable to find that created directory.
2. Granted privileges to that directory and after that while trying to export database, getting following error.
SQL> expdp system/oracle@WIND schemas=plm1user directory=dir3 dumpfile=E:\DBacku
p\datafile\DBDump logfile=E:\DBackup\datafile\db_exp.log exclude=statistics;
SP2-0734: unknown command beginning "expdp syst..." - rest of line ignored.
SQL> $expdp system/oracle@WIND schemas=plm1user directory=dir3 dumpfile=E:\DBack
up\datafile\DBDump logfile=E:\DBackup\datafile\db_exp.log exclude=statistics;
Export: Release 11.2.0.3.0 - Production on Wed Mar 25 23:43:27 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39088: file name cannot contain a path specification
Here, I'm not able to understand why I'm not getting the directory which I had created .
Also, please suggest me how to overcome these errors.
Thanks in Advance