How can I get list of all tables underlying in a MATERIALIZED VIEW

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vkprasad86
    New Member
    • Aug 2018
    • 1
    #1

    How can I get list of all tables underlying in a MATERIALIZED VIEW

    I have list of MATERIALIZED VIEWs and I would like to know the underlying tables in the MVs. This is required to decide whether the MV is ready to be refreshed of not.
    Tags: None
    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501
      #2
      A bit out of my knowledge; however, reading through the oracle stuff I have on hand, the metadata viewer may be your best chance:
      DBMS_METADATA
      https://docs.oracle.com/database/121/ARPLS/d_metada.htm#ARPLS026

      dbms_metadata.g et_ddl
      Looks like a raw dump so the formatting will be up for you to figure out... I've searched on Materialized View and Metadata and have turned up a few dozen such scripts so this appears to be the way to go.
      Last edited by zmbd; Aug 6 '18, 03:00 PM.

        Comment

        Previous template Next
        Working...