Home » RDBMS Server » Server Utilities » Data Pump Error - ORA-39070: Unable to open the log file.
Data Pump Error - ORA-39070: Unable to open the log file. [message #200727] Wed, 01 November 2006 01:57 Go to next message
smora
Messages: 59
Registered: May 2006
Member
Hi

I'm getting an error when trying to use the new Data Pump Export/Import utility.

I am able to create a directory using SQLPLus, and I get the "Directory Created" message, but no directory actually gets created on the server.

SQL> CREATE DIRECTORY datapump AS 'C:\Inetpub\datafile\datapump';

Directory created.

But I dont see the directory created on the server.

Then on the server:

C:\Documents and Settings\Administrator>expdp ******/****** FULL=y DIRECTORY=datapump DUMPFILE=expdata.dmp LOGFILE=expdata.log

Export: Release 10.2.0.1.0 - Production on Wednesday, 01 November, 2006 1:51:55

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 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


Any suggestions are appreciated.
Thank you.
Re: Data Pump Error - ORA-39070: Unable to open the log file. [message #200733 is a reply to message #200727] Wed, 01 November 2006 02:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SQL> create table test as select * from all_objects where rownum <= 10;

Table created.

SQL> create directory data as 'c:\datapump\data';

Directory created.

SQL> host expdp system/oracle tables=test directory=data dumpfile=expdata.dmp lo
gfile=expdata.log

Export: Release 10.1.0.2.0 - Production on Wednesday, 01 November, 2006 12:00

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
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


Note : You have to manually create directory in specified path then after you try ur operation.
ystem32\cmd.exe /c clsSQL> host expdp system/oracle tables=test directory=data d
umpfile=expdata.dmp logfile=expdata.log

Export: Release 10.1.0.2.0 - Production on Wednesday, 01 November, 2006 12:02

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** tables=test directory=
data dumpfile=expdata.dmp logfile=expdata.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SYSTEM"."TEST"                             9.406 KB      10 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  C:\DATAPUMP\DATA\EXPDATA.DMP
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 12:02


SQL>

select directory_name, directory_path from dba_directories;



Hope this helps.
Re: Data Pump Error - ORA-39070: Unable to open the log file. [message #200751 is a reply to message #200727] Wed, 01 November 2006 03:46 Go to previous messageGo to next message
smora
Messages: 59
Registered: May 2006
Member
Thanks! The export worked, log file had this line at the end though:

Job "TEST"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 04:29:48

Is that the XMLSchema object that Data Pump does not support? I did not see any other error in the log file.

Will try import now and see if that works.

Thanks again.
Re: Data Pump Error - ORA-39070: Unable to open the log file. [message #200791 is a reply to message #200751] Wed, 01 November 2006 06:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Is that the XMLSchema object that Data Pump does not support?

ORA-39139: Data Pump does not support XMLSchema objects. string will be skipped. 
Cause: Object has XMLSchema-based columns, which are unsupported by Data Pump. 
Action: Use the original exp and imp utilities to move this object. 

Re: Data Pump Error - ORA-39070: Unable to open the log file. [message #536687 is a reply to message #200791] Thu, 22 December 2011 03:51 Go to previous messageGo to next message
arunsk
Messages: 1
Registered: December 2011
Location: bangalore
Junior Member
Hi Can i import the expdp dump file with sys user or not..?


Why sys user is not able to perform expdp & impdp operation ?


pls clearify
Re: Data Pump Error - ORA-39070: Unable to open the log file. [message #536689 is a reply to message #536687] Thu, 22 December 2011 04:03 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the message?
It has nothing to do with the account.

Regards
Michel
Previous Topic: Datapump with DMP file, no other info
Next Topic: EXP/IMP scripts
Goto Forum:
  


Current Time: Thu Mar 28 11:45:00 CDT 2024