|
|
|
|
| Re: Table Recovery with RMAN. [message #247631 is a reply to message #247470] |
Tue, 26 June 2007 10:56   |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | Forget about flashback feature. I dont want to restore the whole tablespace from RMAN backup. I just want to get a single table which one I had deleted after taking my RMAN backup. Is it possible?
|
may be we can expect that in coming and coming versions not in 10g ..11g..
|
|
|
|
| Re: Table Recovery with RMAN. [message #247774 is a reply to message #247453] |
Wed, 27 June 2007 03:13 |
pratik25
Messages: 4
Registered: June 2007
Location: HYDERABAD
|
Junior Member |
|
|
what is your oracle version if you are using 9i then i think it is not possible becouse there is expor tipe command if you are using 10g then you can recover table from recyclebin of your tablespace
example in 10g
with following commond
flashback table <table_name> to before drop;
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.
hope this help regard pratik
|
|
|
|
|
|
| Re: Table Recovery with RMAN. [message #248350 is a reply to message #247453] |
Thu, 28 June 2007 13:10 |
Yasir Hashmi
Messages: 304
Registered: April 2006
|
Senior Member |
|
|
@Arju
Are there any restrictions for junior members? When michel shifted to orafaq..he posted his first reply as a junior member(i am not comparing).I think the best way to learn is to reply..
Regards
yasir
|
|
|
|
|
|
|
|
|
|
| Re: Table Recovery with RMAN. [message #249905 is a reply to message #247453] |
Fri, 06 July 2007 08:33 |
Staale
Messages: 2
Registered: July 2007
|
Junior Member |
|
|
I would say it is not possible.
You would have to restore into a new database, then do an export of the table you need, and then import this table into the original database.
Would probably also be possible to do a duplicate database with RMAN to a point-in-time before the drop, and then export/import.
Regards,
Staale
|
|
|
|
|
|
| Re: Table Recovery with RMAN. [message #249913 is a reply to message #249912] |
Fri, 06 July 2007 08:54 |
Staale
Messages: 2
Registered: July 2007
|
Junior Member |
|
|
| Michel Cadot wrote on Fri, 06 July 2007 15:50 | Is there any new in your post that is not in the previous ones?
Regards
Michel
|
Yeah..
I actually summed up what he needed to do.
The others used the flashback functionallity, which he explicitly stated he didnt't wanna know about.
But if you are representative of the common attitude on this board.. I take it I won't hang around either.. So you won't have to get any more posts from me.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
