Error: ORA-12988
Text: cannot drop column from table owned by SYS
---------------------------------------------------------------------------
Cause: An attempt was made to drop a column from a system table.
Action: This action is not allowed
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@su To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
fsys.com> cc:
Sent by: Subject: ORA-12988: cannot drop column
[EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
