Re: Cannot drop a column with a long data type

My apologies Mark, I dropped (or believed I dropped) the column thru the OEM gui and there was no message returned.

I checked:

select * from DBA_UNUSED_COL_TABS where table_name = myTable;

came back with 1. So....

ALTER TABLE myTable DROP UNUSED COLUMNS;

BUT..... When I tried to create the materialized view, it came back with the same error:

ORA-00997: illegal use of LONG datatype Received on Tue Mar 28 2006 - 16:50:42 CST