I did created some snapshots in production(22.214.171.124.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
START WITH sysdate
NEXT sysdate + 1/24
AS SELECT * FROM ng_profiles@absd;
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