-
How to Get Materialized View's Definition
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|