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

Leave a Reply