Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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..."Received on Tue May 21 2002 - 14:04:50 CDT