SQL Script to retrieve DDL for materialized view, materialized view log and its indexes

LajosV-Oracle
Posts: 286 Silver Badge
Comments
-
Can we generalize it for table and views also ? Subject just mentions about MV / MV Log.
Thanks.
0 -
It can be generalized for Indexes as well.
Thanks.
0 -
Can we generalize it for table and views also ? Subject just mentions about MV / MV Log.
Thanks for the thoughts, this was a bit intended as mview is a subject area in this community, and the note i referenced in the document discusses retrieving the DDL for a TABLE type object already, while getting DDL of materialized view and materialized view log with the GET_DDL procedure is not widely documented, hence this document to hopefully help in this area. Lajos
Thanks.
0 -
It can be generalized for Indexes as well.
Thanks, good idea. I've implemented it. Regards,
Thanks.
Lajos
0