This content has been marked as final. Show 6 replies
You can only flashback the whole database or flashback some table: you cannot flashback a tablespace or a datafile.
But you can try to restore a tablespace at some point in time in the past with tablespace point in time recovery (TSPITR) but only with database backups: http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV89787.
Edited by: P. Forstmann on 16 févr. 2011 09:00
You could combine the two features flashback database and transport tablespace to in effect flashback a tablespace.
1) flashback database
2) make tablespace read only
3) export metainfo
4) copy datafile
5) recover database to the point before you did flashback database
6) drop tablespace
7) import tablespace again
But the other option would be to do TSPITR as mentioned by others already. Look here for an example:
do take in mind that if you retrieve only one tablespace from the past (no matter via which way) there is the risk that you'll intorduce inconsistency in the data..
Yes, keep in mind not to do something stupid. Thank you for this very good advice that we would not have thought about else :-)
well, you never know you know...cant always only have a tchnical look on a technical issue...ok it is obvious.