Home » RDBMS Server » Backup & Recovery » Data Recovery after SET UNUSED was performed on a column
Data Recovery after SET UNUSED was performed on a column [message #435083] Mon, 14 December 2009 04:07 Go to next message
tunde009
Messages: 3
Registered: October 2009
Junior Member

Hello all,
Please, could anyone help me out on this: I planned prunning down some columns on one of my database tables in order to free up some disk spaces. So, I decided to set some columns as used prior to dropping these columns. I discovered later on that I would still be in need of thses columns and immediately decided to undo my action but my efforts at doing that have been futile.
I need some assistance on the way around this issue.

Thank you.

Tunde
Re: Data Recovery after SET UNUSED was performed on a column [message #435095 is a reply to message #435083] Mon, 14 December 2009 04:43 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Version?
Not possible upto 10g (unless you want recover the database to a point before this happened ) and not sure about 11g.
UNUSED option is meant to a step to facilitate dropping the columns. It cannot be undone.
Previous Topic: Duplicate database: problem with the syntax
Next Topic: RMAN-04006: error from auxiliary database - URGENT
Goto Forum:
  


Current Time: Thu Dec 08 03:51:13 CST 2016

Total time taken to generate the page: 0.18056 seconds