OraFAQ Forum: Server Utilities » ORA-39002,ORA-39070,ORA-29283,ORA-06512

Home » RDBMS Server » Server Utilities » ORA-39002,ORA-39070,ORA-29283,ORA-06512 (oracle 11 g R2 , solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #543082]

Mon, 13 February 2012 01:55

janakors
Messages: 232
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

Report message to a moderator

Re: ORA-39002,ORA-39070,ORA-29283,ORA-06512 [message #543086 is a reply to message #543082]

Mon, 13 February 2012 02:02

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator