Oracle Database Discussions

Dear Guru’s

I have a situation where I need to drop specific columns which are set to unused!

Say, I have 3 unused columns in a table – and now I want to drop only one unused column from that.

SQL> alter table scott.emptest set unused (ENAME);

Table altered.

SQL> alter table scott.emptest set unused (COMM);

Table altered.


Once I set some columns un-used, now I want to drop only one un-used Column “ENAME”

SQL> alter table scott.emptest drop column ENAME;
alter table scott.emptest drop column ENAME
*
ERROR at line 1:
ORA-00904: "ENAME": invalid identifier

which in turn throws this error!

Help appreciated!

Thanks in advanced

Ravi Prakash