Home » SQL & PL/SQL » SQL & PL/SQL » Marked columns
Marked columns [message #191249] Tue, 05 September 2006 07:15 Go to next message
Messages: 20
Registered: July 2006
Location: EGYPT
Junior Member

Hi all ..
i know how to mark the columns that unused ... with SET UNUSED command .. but the question is HOW i retured back this columns if i realized that its important to me .. thax

[Updated on: Tue, 05 September 2006 07:16]

Report message to a moderator

Re: Marked columns [message #191251 is a reply to message #191249] Tue, 05 September 2006 07:23 Go to previous messageGo to next message
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Short answer, you can't.

Re: Marked columns [message #191252 is a reply to message #191249] Tue, 05 September 2006 07:27 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Bad luck, pretty sure you can't do it. With 10g, you can recover the table to a point in time with FLASHBACK TABLE

UNUSED is as good as DROP, except you do not reclaim the space so it is quicker.

Ross Leishman
Previous Topic: How To Extract Conditional Data From Oracle Table To Binary File.
Next Topic: How to sum values on individual records?
Goto Forum:

Current Time: Thu Jul 27 18:26:47 CDT 2017

Total time taken to generate the page: 0.11619 seconds