OraFAQ Forum: Server Utilities » 10g export (merged 3)

Home » RDBMS Server » Server Utilities » 10g export (merged 3) (oracle 10g)

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

10g export (merged 3) [message #435737]

Thu, 17 December 2009 12:06

bkragha
Messages: 2
Registered: December 2009

Junior Member

Hi,
i tried the query
sql>expdp system/manager dumpfile=abc.dmp directory=dir_exp logfile=exp.log full=y;
but i got errors,
please help me to solve that errors the errors are
invalid file creation
unable to create logfile
unable to open sys.utl_file

Report message to a moderator

Re: 10g export (merged 3) [message #435740 is a reply to message #435737]

Thu, 17 December 2009 12:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

Report message to a moderator

Re: 10g export (merged 3) [message #435743 is a reply to message #435737]

Thu, 17 December 2009 12:34

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

sql>expdp system/manager dumpfile=abc.dmp directory=dir_exp logfile=exp.log full=y;

For sure you got errors as expdp is an OS command not a SQL*Plus one.

Regards
Michel

Report message to a moderator

Re: 10g export (merged 3) [message #435781 is a reply to message #435743]

Thu, 17 December 2009 22:36

bkragha
Messages: 2
Registered: December 2009

Junior Member

ya sorry for the mistake..i'm new to oracle..

Report message to a moderator

Re: 10g export (merged 3) [message #435844 is a reply to message #435781]

Fri, 18 December 2009 06:47

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

bkragha wrote on Fri, 18 December 2009 10:06

ya sorry for the mistake..i'm new to oracle..

Hi,
This will help you.

Utilities
And Even This

Oracle Documents

sriram Smile

[Updated on: Fri, 18 December 2009 06:50]

Report message to a moderator

Previous Topic:	sequence in control file
Next Topic:	reinstalling exp/imp 9i utilities

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:20:37 CDT 2024