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





19 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...


Aw, this was an incredibly good post. Spending some time and actual effort to make a superb article… but what can I say… I procrastinate a lot and don't manage to get nearly anything done.

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

Zheng junxai5 said...

zhengjx20160428
louis vuitton outlet
adidas superstar
ray ban eyeglasses
kobe 8
burberry outlet online
coach outlet clearance
replica watches
gucci bags
basketball shoes
coach factory outlet
coach outlet clearance
louis vuitton outlet
coach factory outlet online
jordan shoes
louis vuitton purses
nike trainers sale
coach outlet store
louis vuitton purses
christian louboutin outlet
coach outlet
tiffany and co jewelry
louis vuitton outlet online
hollister clearance
ray bans
michael kors
jordan 3 powder blue
coach outlet
louis vuitton outlet stores
canada goose jackets
louis vuitton outlet online
adidas superstar trainers
coach factory outlet online
kate spade handbags
louis vuitton outlet online
nike air max uk
designer handbags
nike roshe run
gucci outlet
coach factory outlet online