Hi, Tracey,
>From my own test, I remember data in a column set unused can still be dumped to
a trace file. Depending on your knowledge of interpreting datafile dump, you
can get the result back one row at a time (or even write a script to automate
it; nobody outside Oracle can say that's easy).
ra: Multiple recipients of list ORACLE-L
> Asunto: RE: 8i - Seeing which columns disabled
>
> Voss, my guess is that the SET UNUSED command will drop the column !!
> and you cannot get the column back...
>
> i tried to run the command on a table created by SYS
>
> SQL
rom table owned by SYS
you see...the error returned is cannot DROP column.. !!!
> --
> From: Voss, Tracey Lee[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 11:40 AM
> To: 'Rahul'; Oracle DBA 2 (E-mail)
> Subject: RE: 8i - Seeing wh
