Bug 9937133-COPY_STATISTICS doesn's copy stats for partitioned table_9937133.8

rongshiyuan發表於2014-08-24

Bug 9937133 - COPY_STATISTICS does not copy stats for partitioned tables (Doc ID 9937133.8)


Bug 9937133  COPY_STATISTICS does not copy stats for partitioned tables

 This note gives a brief overview of bug 9937133.
 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 (Not specified)
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 9937133 is first included in

Interim patches may be available for earlier versions - click here to check.

Symptoms:

Related To:

  • (None Specified)

Description

This bug is only relevant when using Partitioned Tables 
DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS( .. copy_statistics=>true ) does not
copy statistics for partitioned tables in 11.1 or 11.2 - it did in 10.2. Rediscovery Notes Copy_table_dependents does not copy statistics for partitioned interim table Workaround set clone_statistics parameter to FALSE
 execute DBMS_GATHER_STATISTICS on the newly redefined table
HOOKS PACKAGE:DBMS_REDEFINITION NEED:PART LIKELYAFFECTS XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XAFFECTS_11.2.0.3 XAFFECTS_V11020003 AFFECTS=11.2.0.3 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_CBO TAG_DBMSPKG TAG_PART CBO DBMSPKG PART FIXED_11.2.0.4 FIXED_12.1.0.1

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:9937133 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
 

Document Details

 
Email link to this documentOpen document in new windowPrintable Page
Type:
Status:
Last Major Update:
Last Update:
PATCH
PUBLISHED
6/17/2014
6/17/2014
     
 

Related Products

 
Oracle Database - Enterprise Edition
     
 

Document References

 
No References available for this document.
     

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1256720/，如需轉載，請註明出處，否則將追究法律責任。

相關文章