Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    492

    Unanswered: Source code for materialized view

    Does anyone know where the source code for a materialized view gets stored? I've looked in all_source, all_views..etc, but I cannot find it. I'm looking for the actual source used to create it - I'm basically trying to see when it gets refreshed.

    Thanks!
    Oracle OCPI (Certified Practicing Idiot)

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    SQL> DESC DBA_MVIEWS
    Name Null? Type
    ----------------------------------------- -------- -----------------
    OWNER NOT NULL VARCHAR2(30)
    MVIEW_NAME NOT NULL VARCHAR2(30)
    CONTAINER_NAME NOT NULL VARCHAR2(30)
    QUERY LONG
    QUERY_LEN NUMBER(38)
    UPDATABLE VARCHAR2(1)
    UPDATE_LOG VARCHAR2(30)
    MASTER_ROLLBACK_SEG VARCHAR2(30)
    MASTER_LINK VARCHAR2(128)
    REWRITE_ENABLED VARCHAR2(1)
    REWRITE_CAPABILITY VARCHAR2(9)
    REFRESH_MODE VARCHAR2(6)
    REFRESH_METHOD VARCHAR2(8)
    BUILD_MODE VARCHAR2(9)
    FAST_REFRESHABLE VARCHAR2(18)
    LAST_REFRESH_TYPE VARCHAR2(8)
    LAST_REFRESH_DATE VARCHAR2(9)
    STALENESS VARCHAR2(9)
    AFTER_FAST_REFRESH VARCHAR2(9)
    COMPILE_STATE VARCHAR2(13)
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jan 2004
    Posts
    492
    OH man had no idea about that table. I havent worked with them all too often and it shows - I definitely owe you one!

    Thanks so much for the quick response!
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

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