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
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
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.
Previous Topic: Imp
Next Topic: Max length error while using SQL*Loader
Goto Forum:
  


Current Time: Sat Dec 10 10:44:44 CST 2016

Total time taken to generate the page: 0.11920 seconds