| Data Pump Error - ORA-39070: Unable to open the log file. [message #200727] |
Wed, 01 November 2006 01:57  |
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  |
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 |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
