Tuesday, February 15, 2011

ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", ORA-29283: invalid file operation

This problem is encountered when you try to import a data-pump dump file.
Actually, it is somewhere related to permission issues and also due to mismatch of the steps performed during import operation.

Solution : Perform the below steps to resolve this issue(---in sequence)

1.)Create data-pump directory
--Create directory datapump as 'c:\data\';

2.) Grant permission now to this directory

--Grant read,write on directory datapump to SCOTT;

3.)Copy the desired dump-file at this location('c:\data\')

4.)Start import now..

:-)best of luck





20 comments:

Anonymous said...

it's quit helpful.
al d best........

rajupa said...

Hi Vishwanath,

can you clearly say wat is the use of crating a directory which is not visible and to grant permissions to the user?

Vishwanath Sharma said...

@rajupa Assume datapump directory as a pointer to the location where all dump files and log files are created.
It does not have any physical appearance.

It is helpful bcoz we don't have to specify the path for dumpfiles and logfiles.

HTH:-)

Anonymous said...

Great post. I was checking constantly this
blog and I am impressed! Very useful information specially the
last part :) I care for such information a lot.
I was seeking this certain information for a long time. Thank you and best of luck.
Here is my blog post how to get your ex back

Anonymous said...

Everyone loves it whenever people get together and share opinions.
Great website, keep it up!
Also visit my blog post ... free iphone 5

Anonymous said...

[url=http://dcxvssh.com]FOnGfuF[/url] , UzHRolwFWgqz , http://yuxeflk.com

Hardik Chheda said...

HOw to copy .dmp file to C:\data?
I don'r see data directory in my harddrive?

Anonymous said...

Everything is very open with a very clear explanation of the issues.
It was really informative. Your site is extremely helpful. Thanks
for sharing!
My web page work from home jobs

Anonymous said...

wonderful points altogether, you just gained a new reader.
What might you suggest about your put up that you just made a few days in the past?

Any positive?
Also see my website - rid of acne overnight

Anonymous said...

I almost never write cоmments, but after
looking at а few of thе remаrks on this
page "ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SΥЅ.
UTL_FILΕ", ORA-29283: invalid file operation".
I actually do have a few questions foг you if yоu ԁo not mind.
Coulԁ it be ѕіmply me or do ѕome οf the
responses look like they are coming from brain dead іndiviԁualѕ?
:-P And, if yοu аre wгiting аt other sites,
I would liκe tο kеep uр with evегything
new you have to рost. Would уou make a list
of аll of уour sociаl community sіtes like your lіnkedin ρrofile, Fаcebooκ
pagе or tωitter feed?

Also visіt mу wеbsite: http://raspberryketoned.co.uk

Anonymous said...

Εveгything is verу open wіth а сlear description of the сhallenges.
It ωas definitelу infοrmative. Your site
is extremely helpful. Many thanks foг ѕhагing!



Fееl frеe to surf to my homеpage :: Vistaprint Coupon

Anonymous said...

I'm not sure where you'rе gettіng yоur information, but good topіс.
I neеԁs to spenԁ ѕome tіme leaгnіng morе οr
unԁегstandіng more. Thanκs for exсellent infοrmatiоn І was lοoking fоr this іnformation fοг mу
mіsѕiοn.

Viѕit my blog post; Raspberry Ketone

Anonymous said...

Fellas, subsequent time you purchase the capsule, request your companions when they want
a person. This should double up the sale with the
anti-impotence medicine Cialis. A modern getting indicates the erectile dysfunction tablet that has pepped up the sexual life
of males is proving for being effective in the event of women of all ages suffering from a
sexual disinterest. The analysis underlines which the
drugs is effective for girls approximately it does in the event
of men if not much more.

Feel free to visit my blog post - Buy Cialis Online - Erection Treatment Pills Summer 2013

Anonymous said...

Read Full Article can you buy propecia in mexico - buy propecia dublin

Anonymous said...

Executed same command with sequence but still getting error :

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

Anonymous said...

if we give IP Address instead of server name in dirctry path will it work..?

instead of

CREATE OR REPLACE DIRECTORY P_DIR AS '\\server_01\T_EV';

we have given IP in path :

CREATE OR REPLACE DIRECTORY P_DIR AS '\\21.123.12.14\T_EV';

will it work ?

Anonymous said...

smokeless cigarettes, ecig forum, vapor cigarette, e cig forum, e cigarette, best electronic cigarette

raybanoutlet001 said...

ugg boots
michael kors handbags outlet
christian louboutin shoes
hermes belts
fitflops
oakley sunglasses
michael kors uk
ralph lauren
nike outlet
nike roshe

Unknown said...

balenciaga
offwhite
adidas nmd
michael kors outlet
yeezy boost
birkin bag
kyrie 4
chrome hearts online
adidas tubular
curry 4

yanmaneee said...

coach outlet sale
adidas nmd
russell westbrook shoes
air max 95
fila sneakers
coach outlet
michael kors handbags
yeezy shoes
huaraches
lebron 15