Home » RDBMS Server » Server Utilities » Data Pump utilities (Explain me how to use data pump utility)
Data Pump utilities [message #355243] Thu, 23 October 2008 03:56 Go to next message
kolipaka
Messages: 7
Registered: October 2008
Junior Member
Hi Guys,

Please explain me and give me sample syntax for to use data pump instead of import/export utility.

Thanks in advance.

Regards,
Lakshman

Report message to a moderator

Re: Data Pump utilities [message #355244 is a reply to message #355243] Thu, 23 October 2008 03:58 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
CREATE DIRECTORY dpump_dir1 AS ‘/usr/apps/datafiles’;


GRANT READ,WRITE ON DIRECTORY dpump_dir1 TO scott;

expdp username/password DIRECTORY=dpump_dir1 dumpfile=scott.dmp

Report message to a moderator

Re: Data Pump utilities [message #355247 is a reply to message #355243] Thu, 23 October 2008 04:03 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

This Link will give you good start .

Smile
Rajuvan.

Report message to a moderator

Previous Topic: Imp
Next Topic: Max length error while using SQL*Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 16:30:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.