ORA-04021 During DROP MATERIALIZED VIEW

(Doc ID 2418006.1)

Last updated on JULY 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

A 'DROP MATERIALIZED VIEW' operation gets the error ORA-04021. There are operations being performed on other tables in the same time frame which could include long running DML statements.

The trace file of the error message has the function 'qsmqUpdateTableMetadataBits'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms