Home
Main Menu
Home
Help Docs
Newbies
Corporates
Gnu/Linux Distros
Programming
Databases
Links
Search
Regular
News
Interviews
Aaj Ka Tip
Aaj Ka Command
Community
Blogs
Wiki
Forums
Services
Free Software
Latest
Popular
Who's Online
We have 77 guests online

How to take backup of a oracle schema Print E-mail
How to take backup of a oracle schema

You can use Export/Import OR Data pump.

For export(this command can be used to generate a backup file on the client machine)
exp user/password@database owner=user file=datafile.dmp log=logfile.log

where
database=db entry from tnsnames.ora,user=user-id to connect with,
password=password of the user connected with, 
owner=schema which needs to be exported,

more options can be expplored by
exp help=y


For data pump(this command can be used to generate a backup file on the server machine)
expdp user/password@database schemas=SCOTT directory=TEST_DIR dumpfile=datafile.dmp logfile=logfile.log

For more details

http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

Next >



Polls
Have you visited this site earlier?
  
gnulinuxclub
Join Us
About Us
Contact Us
Support Us
Acknowlegdement
Login(only for dev.)

Royalty Free Images

O'Reilly User Group discount!




Powered By GIMP GIMP
Contact Webmaster Copyleft 2011 gnulinuxclub.org