RE: 8i - Seeing which columns disabled

From: Trassens, Christian <CTrassens_at_uni2.es>
Date: Fri, 23 Mar 2001 00:40:59 -0800
Message-ID: <F001.002D5B5C.20010322235531@fatcity.com>

............because is a object of sys. Is similar to intend creating a

trigger for a object of sys................Therefore, you can do it in

another schema.

> -----Mensaje original-----
> De: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Enviado el: viernes 23 de marzo de 2001 5:55
> Para: 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> 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:tracey.voss_at_au.unisys.com]
> > 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:rahul_at_ratelindo.co.id]
> > > 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:tracey.voss_at_au.unisys.com]
> > > > 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
> > > oracledba-unsubscribe_at_LAZYDBA.com
> > > > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > > > 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: rahul_at_ratelindo.co.id
>
> 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: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

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: ListGuru_at_fatcity.com (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).

Received on Fri Mar 23 2001 - 02:40:59 CST