423,103 Members | 1,428 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,103 IT Pros & Developers. It's quick & easy.

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

P: 1
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.
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,202
A bit out of my knowledge; however, reading through the oracle stuff I have on hand, the metadata viewer may be your best chance:
https://docs.oracle.com/database/121...a.htm#ARPLS026
dbms_metadata.get_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.
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.