Home » RDBMS Server » Backup & Recovery » Scheme backup
Scheme backup [message #216121] Thu, 25 January 2007 01:54 Go to next message
oikhleif
Messages: 4
Registered: January 2007
Location: Benghazi
Junior Member
I would like to backup specific scheme on the database, but the scheme has relationship (Constraint & forien key) with other sheme.

What is the best way to do the back with having to back up the whole database.


Thank you.
Re: Scheme backup [message #216161 is a reply to message #216121] Thu, 25 January 2007 06:19 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For a tablespace level backup, you can use RMAN to backup specific tablespaces (if these schemas are using different tablespaces).
You can use EXP/IMP to take a logical backup of those schemas in user mode. But be adviced that, exp/imp is NOT a backup. It is like a backup and never depend on solely on exported dumps.

[Updated on: Thu, 25 January 2007 06:19]

Report message to a moderator

Previous Topic: Standby database.
Next Topic: backup for oracle 9i
Goto Forum:
  


Current Time: Tue Dec 06 06:33:59 CST 2016

Total time taken to generate the page: 0.07743 seconds