DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: invalid status of new snapshots...in production

  1. #1
    Join Date
    Oct 2000
    Posts
    3
    Hi There


    I did created some snapshots in production(8.1.6.0.0) and the status is INVALID. I don't understand why it's happening in production, bec'z it never happened in QA.

    I'm able to edit and query the data, but my concern is that the object is INVALID. Can anyone please let me know why and what's causing this error....

    here's the snapshot script:
    CREATE SNAPSHOT adev.ng_sh
    ( INITRANS 2
    MAXTRANS 255
    TABLESPACE customerdb)
    REFRESH COMPLETE
    START WITH sysdate
    NEXT sysdate + 1/24
    WITH ROWID
    AS SELECT * FROM ng_profiles@absd;



    Thanx

    sravan

  2. #2
    Join Date
    Feb 2000
    Location
    Long Beach, CA, USA
    Posts
    3
    Im really not sure why that is, but in all my experiences with materialized views, the status has always been "INVALID" when I query dba_objecs

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