Toad World® Forums

Extract DDL for a Materialized View

I have had a request that our users would like to have the extract ddl for a materialized view include permissions and indexes (That are generally associated with the table). They do not really need to extract the table for a Materialized view since it is implicitly created, but they have to always extract the table ddl to get these other items.

If this is something that is not wanted by the majority, then maybe add it to the preferences for Extract MV’s to include table grants, include table indexes, etc…

Thanks.

Hi Dale

Thankyou for your enhancement request, PT 28507327 has been created for consideration

regards
Lidia