How to get the materialized view definition from the dictionary? I mean what table or view it is stored in.
Printable View
How to get the materialized view definition from the dictionary? I mean what table or view it is stored in.
Don't worry guys, I got it. It is USER_MVIEWS table to get it.
select query from user_mviews where mview_name='DVM_PARTY_ID_DVM_V'
HTH
Srini