Return
-
Title
"ON PREBUILT TABLE" table script for materialized view not being exported -
Description
When generating the schema script for materialized views with "ON PREBUILT TABLE" option, Toad for Oracle does not include the underlying table DDL.
-
Cause
Product defect
-
Resolution
WORKAROUND
Go to Schema Browser | Select the table | Script tab | Copy the table DDL manually.
STATUS
Waiting for fix in a future release of Toad for Oracle. -
Defect ID
ST61415