Bug 9935857-lob indexes is missing from dba_objects

Source: Internet
Author: User
Tags compact

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:
  • Wrong Results
  • 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.