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

Report message to a moderator

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: 10708
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.

Report message to a moderator

Previous Topic: Duplicate database: problem with the syntax
Next Topic: RMAN-04006: error from auxiliary database - URGENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 05:00:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.