Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60

    Unanswered: Materialized views and Tablespace

    is there somebody who know in which sys view, i can found the tablespace used by a Materialized view or M view log?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    try with "ALL_TABLES"


    thanks,
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Jul 2003
    Location
    Near Paris France
    Posts
    60
    You are right,
    I must just make the diff between Real tables and materialized views using a join

    Thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    dba_mviews

    hth
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •