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!

Errors ORA-39002,ORA-39070, ORA-29283, ORA-06512, ORA-29283 during import

Avijeet Gorai-OracleFeb 13 2012 — edited Feb 21 2012

Hi all,
I am getting errors during import to 10g database using impdp command.

D:\>impdp nisa_lt/abc123@objtel1 directory=dtpump dumpfile=20120208_expobj.dmp full=y logfile=dbblog.log

Import: Release 10.2.0.1.0 - Production on Monday, 13 February, 2012 17:16:05

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.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-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation

dmpfile history:
Starting "NISA_LT"."SYS_EXPORT_SCHEMA_01": nisa_lt/********@OBJ schemas=nisa_lt directory=dtpump dumpfile=20120208_expobj.dmp logfile=20120208_expobj.log
---
---
Master table "NISA_LT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for NISA_LT.SYS_EXPORT_SCHEMA_01 is:
/oradb/OBJ/oraarch/20120208_expobj.dmp
Job "NISA_LT"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:04:36

and the dump file was done ftp with bin mode set.

It'll be really helpful if some one can guide me on this.