How to Get Materialized View's Definition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Get Materialized View's Definition

  1. #1
    Join Date
    Nov 2000
    Posts
    224

    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.

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Don't worry guys, I got it. It is USER_MVIEWS table to get it.

  3. #3
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    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
  •  



Click Here to Expand Forum to Full Width