Schema compare generate invalid statement for dropping materialized view with index (4326773)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema compare generate invalid statement for dropping materialized view with index
Description

In the Schema Compare feature, when an index on a materialized view is in the reference instance and not in the target instance, the materialized view is dropped correctly (which also drops the index) but a drop index statement is also generated. This drop index statement fails because the index has already been dropped.
Resolution

WORKAROUND:

None

STATUS:

Enhancement request ER 396 has been submitted to Development for consideration in a future release of Toad for Oracle.
Defect ID

ER 396

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title