I'm trying to drop column from the table (8i)
First I have ran the statement
Alter table table1 set unused (COL1)
Table altered.
Secondly I have ran the statement
Alter table table1 drop column(COL1)
I get error following error:
ERROR at line 1:
ORA-00904: invalid column name
Thanks in Advance