| Scheme backup [message #216121] |
Thu, 25 January 2007 01:54  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
