Bug 9935857 - LOB indexes are missing from DBA_OBJECTS

来源于：
Bug 9935857 - LOB indexes are missing from DBA_OBJECTS (文档 ID 9935857.8)

 

这个问题在使用ogg完成oracle database 10gR2 （Linux下） 向oracle database 11.2.0.4（AIX下）的 升级and 迁移 时遇到过，
当时为了核查老db和新db的object数量，就去查询的dba_objects,结果发现对不上。后来进一步检查，就找到了这个mos文章。

如下全文转载该文章：
Bug 9935857  LOB indexes are missing from DBA_OBJECTS   This note gives a brief overview of bug 9935857.
 The content was last updated on: 28-JUN-2013
 Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server  (Rdbms)Range of versions believed to be affectedVersions BELOW 12.1Versions confirmed as being affected

• 11.2.0.2
• 11.2.0.1
• 11.1.0.7
• 10.2.0.4

Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

• 12.1.0.1 (Base Release)
• 11.2.0.3 (Server Patch Set)
• 11.2.0.2 Patch 18 on Windows Platforms

 

Symptoms:

Related To:

• Wrong Results

• Datatypes (LOBs/CLOB/BLOB/BFILE)
• DBA_OBJECTS

 

Description

The view DBA_OBJECTS foes not show objects of type LOB INDEX. Workaround Use DBA_INDEXES to see LOB INDEX objects. 

HOOKS VIEW:DBA_OBJECTS LIKELYAFFECTS XAFFECTS_10.2.0.1 XAFFECTS_V10020001 AFFECTS=10.2.0.1 XAFFECTS_10.2.0.2 XAFFECTS_V10020002 AFFECTS=10.2.0.2 XAFFECTS_10.2.0.3 XAFFECTS_V10020003 AFFECTS=10.2.0.3 XAFFECTS_10.2.0.4 XAFFECTS_V10020004 AFFECTS=10.2.0.4 XAFFECTS_10.2.0.5 XAFFECTS_V10020005 AFFECTS=10.2.0.5 XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_LOB TAG_WRONGRES LOB WRONGRES FIXED_11.2.0.3 FIXED_12.1.0.1 FIXED_WIN:B202P18

 

 

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

 

References

Bug:9935857  (This link will only work for PUBLISHED bugs)
Note:245840.1  Information on the sections in this article