+ Reply to Thread
Results 1 to 3 of 3
  1. 06-10-2004 11:23 AM #1
    Sharma
    Sharma is offline Member
    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.
    Reply With Quote Reply With Quote
  2. 06-10-2004 11:40 AM #2
    Sharma
    Sharma is offline Member
    Join Date
    Nov 2000
    Posts
    224
    Don't worry guys, I got it. It is USER_MVIEWS table to get it.
    Reply With Quote Reply With Quote
  3. 06-10-2004 11:48 AM #3
    Srinivas_Sharma
    Srinivas_Sharma is offline Member
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    select query from user_mviews where mview_name='DVM_PARTY_ID_DVM_V'

    HTH

    Srini
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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