-
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
-
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
