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> alter table t set unused column t1;
alter table t set unused column t1
*
ERROR at line 1:
ORA-12988: cannot drop column from 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 which columns disabled
>
> Hi,
>
> alter table emp set unused column commission.
>
> If you want to drop a column but the table is large and you don't want to
> affect performance during busy hours you can set the column as unused and
> then drop the column later. Obviously if you can wait til later then you'd
> just drop it later but if you need to drop it immediately then you would
> use
> this.
>
> I found though that once marked unused U couldn't find a reference to the
> column name anywhere ie to confirm what columns have been dropped. I get
> the
> feeling that 'set unused' may be an irreversible process?
>
> Tracey
>
> > -----Original Message-----
> > From: Rahul [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, 23 March 2001 15:21
> > To: 'Voss, Tracey Lee'
> > Subject: RE: 8i - Seeing which columns disabled
> >
> >
> > Voss, could you tell me how to mark columns unused ?
> > and what is the use for that
> >
> > thanks
> >
> >
> > > ----------
> > > From: Voss, Tracey Lee[SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, March 23, 2001 11:12 AM
> > > To: Oracle DBA 2 (E-mail)
> > > Subject: 8i - Seeing which columns disabled
> > >
> > > Hi there,
> > >
> > > I've disabled a few columns in a table and I'm now trying
> > to list them
> > > somehow. The views '..._unused_col_tabs' only show the
> > table name, owner
> > > and
> > > number of columns disabled in that table. How do I list the disabled
> > > column
> > > names?
> > >
> > > TIA
> > > Tracey
> > >
> > >
> > >
> > > --------
> > > Think you know someone who can answer the above question?
> > Forward it to
> > > them!
> > > to unsubscribe, send a blank email to
> > [EMAIL PROTECTED]
> > > to subscribe send a blank email to [EMAIL PROTECTED]
> > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > > Tell yer mates about http://www.farAwayJobs.com
> > >
> >
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
