Could anyone tell me if there is a way to drop a column from a view ?

SQL>alter view VIEW_NAME drop column COLUMN_NAME;
---- will not work.

**Or, better yet, I would like to move all the data from a view into a table so then I can modify the table with no problems.

PLEASE HELP.

Im using Oracle8i on Linux Red Hat