Home arrow About Us
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

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 >



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