Column Drop

[irehman]

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

[Oracledba8]

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

oracledba8@orasearch.net

Thanks..