Bug 9935857 - LOB indexes are missing from DBA_OBJECTS

翻译

wx5bcd90b347f01 2021-10-29 14:01:01

这个问题在使用ogg完成oracle database 10gR2 （Linux下）向oracle database 11.2.0.4（AIX下）的升级and 迁移时遇到过，

当时为了核查老db和新db的object数量，就去查询的dba_objects,结果发现对不上。后来进一步检查，就找到了这个mos文章。

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 affected**	Versions BELOW 12.1
*Versions confirmed* as being affected**	11.2.0.2 11.2.0.1 11.1.0.7 10.2.0.4
Platforms affected	Generic (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.