ORA-12083: must use DROP MATERIALIZED VIEW to drop “KISH”.”MVSAL”
Cause:
A materialized view is mistakenly considered as a table or table name is incorrect for drop
kIsH@x3z6zx9<^>drop table KISH.MVSAL;
drop table KISH.MVSAL
*
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop "KISH"."MVSAL"
kIsH@x3z6zx9<^>!oerr ora 12083
12083, 00000, "must use DROP MATERIALIZED VIEW to drop \"%s\".\"%s\""
// *Cause: An attempt was made to drop a materialized view using
// a command other than DROP MATERIALIZED VIEW.
// *Action: Use the DROP MATERIALIZED VIEW command.
//
Action:
Drop either the correct table or drop the MV