Home » RDBMS Server » Server Utilities » ORA-39002,ORA-39070,ORA-29283,ORA-06512 (oracle 11 g R2 , solaris 10)
ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #543082] Mon, 13 February 2012 01:55 Go to next message
janakors
Messages: 199
Registered: September 2009
Senior Member
hi,
i have created a directory for export job as sa_dumps and then
give read and write grants to ops$oracle (which run the expdp) and when i run the export i got following

ORA-39002 - Invalid operation
ORA-39070 - Unable to open log file
ORA-29283 - invalid file operaton
ORA-06512 - at "SYS.UTL_FILE", line 536
ORA-29283 - invalid file operation


Now this means that directory objects is not created as per my knowledge but that is there. i created the directory object as follows

SQL>create or replace directory sa_dumps as '/export/home/oracle/sa_dumps';


kindly advice
Re: ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #543086 is a reply to message #543082] Mon, 13 February 2012 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 66773
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/
"export" is not a database backup

2/
Post the COMPLETE session

3/
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #543176 is a reply to message #543086] Mon, 13 February 2012 05:15 Go to previous messageGo to next message
cookiemonster
Messages: 13777
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is the actual os directory there and does the oracle user have write access?
Re: ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #552605 is a reply to message #543176] Thu, 26 April 2012 18:11 Go to previous message
perry0511
Messages: 5
Registered: April 2012
Junior Member
Verify file and directory access privileges on the file system, and if reading, verify that the file exists.

Oracle error database ORA-29283

[Updated on: Thu, 26 April 2012 18:17]

Report message to a moderator

Previous Topic: cannt read the bad file from java code
Next Topic: impde include
Goto Forum:
  


Current Time: Fri Jan 17 18:56:48 CST 2020