Home » RDBMS Server » Backup & Recovery » Scheme backup
Scheme backup [message #216121] Thu, 25 January 2007 01:54 Go to next message
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: 10677
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: RMAN-08132 during backup archive logs on physical standby database.
Next Topic: Database refresh Steps
Goto Forum:

Current Time: Tue Aug 22 19:26:01 CDT 2017

Total time taken to generate the page: 0.10763 seconds