Consideration: abc.dmp is the dump file from another office, it was export from 10gR2 unix server.They send to us to windows PC shared drive. We ftp this file from windows to our Unix server by binery mode. We put the abc.dump file under the directory /u02/app/exaple/ Our server is sun solaris 10, oracle 10gR2. I log in as myusername, I have dba priv, but I don't have sysdba and sysoper priv.
putty to server,
#su - oracle
$cd /u02/app/exaple/
$ls -l
abc.dmp
abc_imp.sh /*the script use old imp*/
abc_impdp.sh /*databump script but I did not right*/
Can I just do this:
$sqlplus /nolog
SQL>conn [email protected]
passward:****
SQL>CREATE OR REPLACE dump_dir as ' /u02/app/exaple/ '
SQL> EXIT
$ cd /u02/app/exaple/
$ vi ./abc_impdp.sh
/u01/app/oracle/product/10.1.2/bi/bin/impdp [email protected] schema=abc
directory=dump_dir dumpfile=abc.dmp logfile=abc.log
$./abc_impdp.sh
passward: ****
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
Any help? Thnaks!