Database DataWarehousing (MOSC)

MOSC Banner

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

LajosV-Oracle
LajosV-Oracle Posts: 286 Silver Badge
edited May 12, 2011 12:04AM in Database DataWarehousing (MOSC) 4 comments

Comments

  • Nip-Oracle
    Nip-Oracle Posts: 757 Gold Badge
     Can we generalize it for table and views also ? Subject just mentions about MV / MV Log.
    Thanks.
  • Nip-Oracle
    Nip-Oracle Posts: 757 Gold Badge
     It can be generalized for Indexes as well.
    Thanks.
  • LajosV-Oracle
    LajosV-Oracle Posts: 286 Silver Badge
     Can we generalize it for table and views also ? Subject just mentions about MV / MV Log.
    Thanks.
     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

  • LajosV-Oracle
    LajosV-Oracle Posts: 286 Silver Badge
     It can be generalized for Indexes as well.
    Thanks.
    Thanks, good idea. I've implemented it. Regards,
    Lajos

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center