Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-12988: cannot drop column
Error: ORA-12988
Text: cannot drop column from table owned by SYS
The solution seems to be 'do not create objects as sys'.
Drop the tables and create them as another user.
Jared
Ken Janusz <ken.janusz_at_su To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> fsys.com> cc: Sent by: Subject: ORA-12988: cannot drop column root_at_fatcity.c om 12/20/01 11:15 AM Please respond to ORACLE-L
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-LReceived on Thu Dec 20 2001 - 14:16:26 CST
(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: Jared.Still_at_radisys.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).
![]() |
![]() |