>From Metalink:
Problem Description:
====================
While querying "user_objects", under the "OBJECT_TYPE" column, you see a value
of "UNDEFINED" on some of the objects. What does this signify?
The "dba_objects" view shows LOB object type as UNDEFINED ;
but "user_objects" view shows it correctly as LOB.
If you run the query:
select object_type from user_objects;
you see some rows showing a value "UNDEFINED".
What is the object type, when "user_objects" view shows object type as
UNDEFINED?
Solution Description:
=====================
Using the "object_id" column of "user_objects" for the UNDEFINED object, query
obj$:
select type# from sys.obj$ where obj#=<object_id>
If type# returned is 42, then it is an object type that was previously
called a SUMMARY object. This object is created when one runs:
create materialized view ... command.
[Or equivalently "create snapshot..." command. ]
Explanation:
============
The object is most likely a SUMMARY object associated with materialized views.
References:
===========
[BUG:1188948] SNAPSHOT IS SHOWING AS UNDEFINED IN DBA_OBJECTS IN RDBMS 8.1.6
IN SOLARIS 2.6
--- mala singh <[EMAIL PROTECTED]> wrote:
> Hi gurus
> I found that one of objects has status INVALID.
> The following are the output.
> OWNER OBJECT_NAME OBJECT_TYPE STATUS
> ------------ ------------------------------ ------------------ -------
> SCOTT EMP_SNAP UNDEFINED INVALID
>
> How to correct this object.
> Please advice me.
> Thanks.
> -Mala
>
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mala singh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
=====
Gunawan Yuwono
Oracle DBA
Kansas City, USA
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gunawan Yuwono
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
