Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cannot drop column from table owned by SYS

485461Mar 10 2006 — edited Mar 17 2006
Hello everybody,

How can I drop a column of table which is owned by sys? thanks!

Result as follows:
SQL> ALTER TABLE HELLO_TB DROP COLUMN NUM;
ALTER TABLE HELLO_TB DROP COLUMN NUM
*
ERROR at line 1:
ORA-12988: cannot drop column from table owned by SYS

newbie v
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2006
Added on Mar 10 2006
14 comments
10,096 views