 Posted 6/14/2010 10:37:47 AM
|
|
|
|
| ORA-39002 ORA-39070 ORA-39087 with Datapump If you are using the datapump (expdp or impdp etc.) and you get the following errors:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid
There is no directory defined. You have to define it on the server.
Choose a user with the rights to create an directory, start sqlplus and enter following
command:
create directory data_pump_dir as '\exphd\datapump';
for windows...
create directory data_pump_dir as 'x:\exportdrive\datapump';
Be sure, that the directory exists on the os before you define it in the database!
|
|
|
Posted 6/14/2010 10:39:28 AM
|
|
|
|
version : oracle 10g (10.1.0.2.0) for 32 bit windows
when ever i am trying to use this utility expdp from command line it gives me this error'
c:\oracle\product\10.1.0\Db_1\bin> expdp system/password full=y
ORA -39002 : INVALID OPERATION
ORA- 39070 : UNABLE TO OPEN THE LOG FILE
ORA- 39087 : DIRECTORY NAME DATA_DUMP_DIR IS INVALID
PLEASE GUIDE ME do i have to set some more parameter in init file
thanks in advance
|
|
|
Posted 6/14/2010 10:40:07 AM
|
|
|
|
Did you run first:
create directory data_pump_dir as 'C:\oracle';
Then run:
expdp system/password directory=data_pump_dir dumpfile=exp%U.dat full=y That should fix it.
|
|
|
Posted 6/14/2010 10:41:32 AM
|
|
|
|
expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
Export: Release 10.2.0.1.0 - 64bit Production on Friday, 31 March, 2006 11:36:07
Copyright (c) 2003, 2005, Oracle. All rights reserved.
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-39087: directory name DMPDIR is invalid
Need to create a directory first: SQL> CREATE DIRECTORY dmpdir AS '/opt/oracle';
Directory created.
SQL> GRANT read, write ON DIRECTORY dmpdir TO scott;
Grant succeeded.
SQL> SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
DIRECTORY_PATH
--------------------------------------------------------------------------------
/app/oracle/product/10.2.0/rdbms/log/
Should work now.
|
|
|
Posted 6/14/2010 10:42:36 AM
|
|
|
|
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.
|
|
|
Posted 6/14/2010 10:45:02 AM
|
|
|
|
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;
|
|
|
|