Re: Cannot Drop Column

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Fri, 07 Dec 2001 10:07:45 -0800
Message-ID: <F001.003D7AD1.20011207093531@fatcity.com>

Ken,

I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    Ken Janusz                                                         
                       
                    <ken.janusz_at_su       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    fsys.com>            cc:                                           
                       
                    Sent by:             Subject:     Cannot Drop Column               
                       
                    root_at_fatcity.c                                                     
                       
                    om                                                                 
                       
                                                                                       
                       
                                                                                       
                       
                    12/07/2001                                                         
                       
                    10:05 AM                                                           
                       
                    Please respond                                                     
                       
                    to ORACLE-L

8.1.7 logged in as SYS.

Will not let me drop a column because it belongs to SYS.

If I am logged in as SYS why can't I drop a column owned by SYS?

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

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: 
  INET: DBarbour_at_austin.isd.tenet.edu

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 Dec 07 2001 - 12:07:45 CST