Return
-
Title
When compiling a Materialized View in Schema Browser it shows 'compiled with errors' but does not show the errors -
Description
A Materialized View has a ! (needs compiled) against it in the Schema Browser. Compiling the MV results in:
16:37:31 Info: 1 materialized view compiled with errors.
-
Resolution
WORKAROUND
Load the script in the Editor and use F9 to run. This will display the errors details in the Editor window with the script.
STATUS
Enhancement request TOR-2096 (to display the errors) has been rejected, as Oracle is not supplying the compilation errors, so Toad can't report.
-
Defect ID
TOR-2096