Re: Snapshot "UNDEFINED" object invalid

Jason S. Person wrote:
>
> Here's what I'm doing:
> create snapshot TEST as select * from TEST_at_TEST_MASTER;
>
> This creates two objects of name TEST - a table and an object of type
> "UNDEFINED".
>
> Now, here's the problem:
> The status of the "UNDEFINED" object will change to "INVALID" anytime
> I do a refresh. The refresh succeeds, all of the data is moved over
> and everything appears great, except that the status is "INVALID". I
> can recompile the snapshot and the status remains "VALID" until I do
> another refresh at which time the status changes back to "INVALID".
>
> I have searched every book I can find to get more information on the
> "UNDEFINED" object, but can't find anything. If anyone has a
> suggestion, I'd be very appreciative.

Take a look at the definition for DBA_OBJECTS (from DBA_VIEWS). "Undefined" is anything that they forgot to give a nice label to. The most common one I've is materialised views in some 8i versions.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."