ORA-12083: must use DROP MATERIALIZED VIEW to drop “KISH”.”MVSAL”
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. //
Drop either the correct table or drop the MV