|
|
|
|
|
|
| Re: recover a table from an rman backup [message #144059 is a reply to message #143936] |
Mon, 24 October 2005 18:31   |
Vamshee
Messages: 32
Registered: February 2005
|
Member |
|
|
Hi Alan
If this is happened in 9i, The only way to restore your table is to restore your database from a backup and to recover to a point in time just before you dropped the table. However, you will lose all information since that time.
Oracle 10g makes life easier with the ability to recover a dropped table similar to recovering a file from a Windows Recycle Bin.
And in case if this on 10g,
Eg: You dropped the DEPT table, which belongs to the USER_DATA tablespace
You can use the following command to recover a dropped table:
FLASHBACK TABLE <table_name> TO BEFORE DROP;
Alternatively, you can use Oracle Enterprise Manager 10g to recover a dropped table. You can query the USER_RECYCLEBIN or DBA_RECYCLEBIN view to identify the objects that have been dropped by you or all users.
You can use the SHOW RECYCLEBIN command to view the objects that can be undropped.
Note:
1)You can flash back a dropped table, provided the table is stored in a locally managed non-SYSTEM tablespace.
2)If another table with the same original name exists in your schema, you must use the RENAME TO clause with the FLASHBACK TABLE command while restoring a dropped table.
Hope this helps
Regards
Vamshee
|
|
|
|
| Re: recover a table from an rman backup [message #144119 is a reply to message #144059] |
Tue, 25 October 2005 02:37 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
@Vamshee
You said:
If this is happened in 9i, The only way to restore your table is to restore your database from a backup and to recover to a point in time just before you dropped the table. However, you will lose all information since that time.
I am sorry, but its not the only way. What Mahesh pointed out is another & more suitable way.
@Alan
If its 9i, restore backup of database to new database & recover upto a point before you dropped the table. Take an export then & import that into your current database.
--Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
