From:
Bug 9935857-lob indexes is missing from dba_objects (document ID 9935857.8)
This issue was encountered when using OGG to complete the upgrade and migration of Oracle database 10GR2 (under Linux) to Oracle database 11.2.0.4 (under AIX),
At that time in order to check the old DB and the new DB object number, went to query the dba_objects, the results found not. After further examination, the MOS article was found.
The article is reproduced as follows:
Bug 9935857 LOB indexes is missing from dba_objects This note gives a brief overview of bug 9935857.
The content is last updated on:28-jun-2013
Click here for details on 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 a fixed in |
- 12.1.0.1 (Base Release)
- 11.2.0.3 (Server Patch Set)
- 11.2.0.2 Patch on Windows platforms
|
Symptoms: |
Related to: |
|
- Datatypes (Lobs/clob/blob/bfile)
- Dba_objects
|
Description
Workaround
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 is confirm that is encountering this problem. For questions the This bug is consult Oracle support. |
References
bug:9935857 (this link would only work for
PUBLISHED bugs)
note:245840.1 Information
on the sections in this article
Bug 9935857-lob indexes is missing from dba_objects