Hi All,
I encounter the error message when I tried to drop user cascade. The error code is ORA-12083 must use DROP MATERIALIZED VIEW to drop %s.%s

After that I try to use DROP MATERIALIZED VIEW command to drop my Matarialized views. But it say the Materialized view is not found - ORA-12003 snapshot "mymaterialized" not found


Your input is very much appreaciated.... TQ