Alter table <tablename> drop column <col>
577696Sep 12 2007 — edited Sep 13 2007I tried to drop a column from a table created by sys user. Being a sys user I am unable to drop the column. Please explain.
SQL> alter table test move tablespace users;
Table altered.
SQL> alter table test drop column two;
alter table test drop column two
*
ERROR at line 1:
ORA-12988: cannot drop column from table owned by SYS
Here two is the column name.
Regards
Vijay Kumar