Column Drop

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

Hi,

Once you have Unused Columns, You can not ask to to drop the column as you tried.

Look

Alter Table Mytable
Set Unused (columnName);

Now... You can't say to Drop Directly... Use This Instead

Alter Table Mytable
Drop Unused Columns; ... Don't change any thing in this except to give the Table name ..

It should be fine... Any question

[email protected]

Thanks..