Unused columns in 8i

Hi,

I have set a column unused in 8i. Now I want to use it again. So what is syntex for that?

You have to drop that column firs by

ALTER TABLE tab DROP UNUSED COLUMNS;

and then add a new column with the same name. There is no way you can reuse the column (I mean it's data) once it has ben marked UNUSED.