By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,830 Members | 1,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,830 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.
Aug 2 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,327
A bit out of my knowledge; however, reading through the oracle stuff I have on hand, the metadata viewer may be your best chance:
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.
Aug 6 '18 #2

Post your reply

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