Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to import(getting error on impdp command)

899419Nov 10 2011 — edited Nov 10 2011

hi,

i have taken the export of my database db6 using below command
expdp system/password@db6 SCHEMAS=(CODASYL,DNET,FINANCE,BILLPAY) DUMPFILE=qr_bkp_9nov.dmp DIRECTORY=qr_bkp LOGFILE=qr_bkp_9nov.log PARALLEL=4
the dump was created success fully(i have also created the directory n given permission before executing the above command).

now on a different server i have created the directory as below

CREATE OR REPLACE DIRECTORY qr_bkp AS '/opt/quikremit';
GRANT READ, WRITE ON DIRECTORY qr_bkp to HR;

and when executing the command for import i am getting the below error.

bash-3.00$ impdp SCHEMAS=(CODASYL,DNET,FINANCE,BILLPAY) DIRECTORY=qr_bkp DUMPFILE=qr_bkp_9nov.dmp LOGFILE=qr_bkp_9nov1.LOG PARALLEL=4

Import: Release 10.2.0.1.0 - 64bit Production on Thursday, 10 November, 2011 13:47:37

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Username: HR
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
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

some one plz help????