Re: ORA-12988: cannot drop column

Ken,
This subject was discussed at some length in the past week or two. If I remember correctly the only way and approved method is the ignore the columns and recreate the tables as the proper owner.
ROR mª¿ªm

>>> ken.janusz_at_sufsys.com 12/20/01 02:15PM >>>
I have created a DB as SYS and added columns to some of the tables as SYS. When I try to drop some of these columns I get this error.

ORA-12988: cannot drop column from table owned by SYS

How can I get around this problem?

Thanks,
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: Ron Rogers
  INET: RROGERS_at_galottery.org

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).