Master Note for Partitioning
Relevant Links
Overview of Partitioning:
Document 1390871.1 Purpose and Benefits/Advantages/Uses of Table Partitioning
Oracle ® Database Concepts 11g Release 2 (11.2) Part Number E16508-05 Chapter 4
Oracle ® Database VLDB and Partitioning Guide 11g Release 2 (11.2) Part Number E16541-08
Relevant articles regarding partitions creation and maintenance:
Document 69715.1 Creating & Adding Table and Index Partitions
Document 165303.1 Examples about Insert into Range Partitioned Tables
Document 164874.1 Example of Script to Create a Range Partition Table
Document 166652.1 Example of Script to Maintain Range Partitioned Table
Document 149116.1 Oracle9i Partitioning Enhancements, LIST Partitioning
Document 209368.1 Range List Partitioning - Oracle 9.2 Enhancement
Document 276158.1 Partitioning Enhancements in Oracle 10g
Relevant articles regarding latest features:
Document 452447.1 11g Partitioning Enhancements
Document 785462.1 11g New Features:System Partitioning
Document 805976.1 11g New Features:INTERVAL PARTITIONING
Document 943567.1 11g new feature: Extended Composite Partitioning (Overview, Example and Use)
Document 761251.1 Oracle 11G Reference Partitioning examples
Document 466352.1 11g Feature: Interval Partitioning Example
Document 757754.1 Interval Partitioning By Week
Relevant articles regarding partition pruning:
Document 179518.1 Partition Pruning and Joins
Document 166118.1 Partition Pruning/Elimination (This article provide a very detailed example of how to identify which partitions/subpartitions were accessed during an execution of a statement using event 10128)
Document 74181.1 Partitioning Tables with User-Defined Types and LOBs
Document 1304370.1 How to use Partition Names for ref partitioning tables when Split is used
Document 846405.1 How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition
'How to' relevant articles for partitioned indexes:
Document 69374.1 Partitioned Indexes: Global, Local, Prefixed and Non-Prefixed
Document 74224.1 How to Create Primary Key Partitioned Indexes
Document 795854.1 How To Update Both Global and Local Indexes when Moving Table Partition?
NOTE:1073195.1 - DataPump Import (IMPDP) Is Slow When Importing Partitioned Tables
NOTE:1077819.1 - Changing Buffer_pool for a Partitioned Table Requires Database to be Bounced
NOTE:179518.1 - Partition Pruning and Joins
NOTE:1070693.6 - How to Partition a Non-partitioned / Regular / Normal Table
NOTE:198120.1 - Exchange Partitions - Common Problems
NOTE:1081230.1 - INTERVAL RANGE Partition Giving ORA-14400
NOTE:1266993.1 - How To Use Multicolumn Partitioning Keys
NOTE:1084542.1 - Ora-600 Internal Error Code, Arguments: [Kkedsamp: Bad Partitioning Info.], [1290], [663]
NOTE:209070.1 - Partition Pruning Based on Joins to Partitioning Criteria Stored in Dimension Tables
NOTE:209368.1 - Range List Partitioning - Oracle 9.2 Enhancement
NOTE:74181.1 - Partitioning Tables with User-Defined Types and LOBs
NOTE:74224.1 - How to Create Primary Key Partitioned Indexes
NOTE:1389394.1 - Ora-1476 When Collecting Statistics On Empty Table with Granularity = Approx_Global
NOTE:1395403.1 - Master Note for Most Frequent Errors during Partition operations
NOTE:69715.1 - Example for Creating And Adding Table and Index Partitions To Ranged Partitioned Table
NOTE:272312.1 - How to Recreate a Table Partition After Having Dropped the Datafile?
NOTE:175258.1 - How to Compute Statistics on Partitioned Tables and Indexes (9iR2 and prior)
NOTE:199623.1 - Top Issues Encountered Regarding Split Partition
NOTE:466352.1 - 11g Feature: Interval Partitioning Example
NOTE:752904.1 - DataPump Export Of Partitioned Table Is Very Slow And Apparently Hangs
NOTE:785462.1 - 11g New Features: System Partitioning
NOTE:372357.1 - Fast Split Partitioning Not Ocurring When It Was Expected
NOTE:1329441.1 - White Papers for Data Warehousing Components in the Oracle Database
NOTE:276158.1 - Partitioning Enhancements in Oracle 10g
NOTE:790630.1 - ORA-600 [Kkpamdgspam1] When Joining Partitioned Tables at Different Partitioning Levels
NOTE:846405.1 - How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition
NOTE:795854.1 - How To Update Both Global and Local Indexes when Moving Table Partition?
NOTE:805976.1 - 11g New Features:INTERVAL PARTITIONING
NOTE:164874.1 - Example of Script to Create a Range Partition Table
NOTE:165701.1 - How to Implement Hash Partitioning on IOT Tables in 9i & Above
NOTE:166118.1 - How to see Partition Pruning Occurred?
NOTE:166215.1 - Top Partition Performance Issues
NOTE:166652.1 - Example of Script to Maintain Range Partitioned Table
NOTE:472449.1 - How To Partition Existing Table Using DBMS_Redefinition
NOTE:757754.1 - Interval Partitioning By Week
NOTE:761251.1 - Reference Partitioning Examples in Oracle 11G and above
NOTE:378138.1 - What to check when the fast split partitioning does not appear as working?
NOTE:1390871.1 - Purpose and Benefits/Advantages/Uses of Table Partitioning
NOTE:389804.1 - Range Partition Splitting Fails with ORA-01882
NOTE:165303.1 - Examples about Insert into Range Partitioned Tables.
NOTE:165599.1 - Top Partitioned Tables Issues
NOTE:1319225.1 - Collect Incremental Statistics For a Large Partitioned Table in 10g and in 11g
NOTE:1304370.1 - How to use Partition Names for ref partitioning tables when Split is used
NOTE:1417133.1 - How To Collect Statistics On Partitioned Table in 10g and 11g
NOTE:729149.1 - Table/Index (partition) Growth Is Far More Than Expected
NOTE:727306.1 - Ora-14074 When Trying To Add Partition
NOTE:430239.1 - How To De-install Partitioning Option From Enterprise Edition?
NOTE:434743.1 - Can The Partitioning Option Be Deinstalled When System Partitioned Objects Are Used
NOTE:452447.1 - 11g Partitioning Enhancements
NOTE:1289275.1 - OBJ$-PARTOBJ$-NOTE:405922.1 - ORA-07445 [evaopn2] Query With Bit Mapped Indexes And Partitioning
NOTE:854332.1 - How To Introduce Interval Partitioning into a Range Partitioned Table
NOTE:111990.1 - ORA-14508: ANALYZE PARTITION TABLE VALIDATE STRUCTURE CASCADE
NOTE:1224663.1 - DataPump Import (IMPDP) Raises Errors ORA-39001 ORA-39203 When Importing A Partition Over A Network Link
NOTE:1281826.1 - What Types of Partitioning Are Eligible for Partition Change Tracking (PCT) Fast Refresh?
NOTE:784989.1 - ORA-600 [kdblGetRDBA] During Create Table with Compression and Partitioning
NOTE:69374.1 - Partitioned Indexes: Global, Local, Prefixed and Non-Prefixed
NOTE:1479115.1 - Interval Partitioning Essentials - Common Questions - Top Issues
NOTE:232628.1 - Fast Split partitioning in 9iR2
NOTE:237538.1 - How to Move from ANALYZE to DBMS_STATS on Partitioned Tables - Some Examples
NOTE:887659.1 - Getting ORA-01410 for Partitioned Tables Without Any Apparent DDL On The Partitions.
NOTE:943567.1 - 11g new feature: Extended Composite Partitioning (Overview, Example and Use)
NOTE:959116.1 - Interval Partitioning Does Not Inherit Logging
NOTE:1312416.1 - Common Questions on the Partitioning Option Installed in the Oracle Database (Licensing, Install, Remove)
NOTE:1050294.1 - Stale_Stats of Sub Partition Index Reported Incorrectly in Dba_Tab_Statistics
NOTE:1050966.1 - ORA-14652 When Using Reference Partitioning
NOTE:149116.1 - Oracle9i Partitioning Enhancements, LIST Partitioning.
NOTE:1401064.1 - Common Questions and Errors on Partition Operations Involving Tablespaces of Different Block Sizes
NOTE:1482460.1 - How to Create Partial Global/Local Indexes for Partitioned Tables in Oracle 12c
NOTE:1519042.1 - How to Create Interval-Reference Partitioned Tables in Oracle 12c
NOTE:1482264.1 - How to Drop/Truncate Multiple Partitions in Oracle 12C
NOTE:1482263.1 - How to Merge Multiple Partitions in Oracle 12C
NOTE:1482230.1 - Splitting a Partition Into Multiple Partitions in Oracle 12C
NOTE:1482456.1 - How to Add Multiple Partitions in Oracle 12C
NOTE:1681857.1 - Example of Script to Create a Composite HASH-HASH Partitioned Table
=================================================================
SCOPE
The document will cover the following topics:
Concepts/Definitions
How-To Section
Troubleshooting Section
Known issues
Additional Resources
Concepts/Definitions
How-To Section
Troubleshooting Section
Known issues
Additional Resources
DETAILS
Concepts/Definitions Section
Overview of Partitioning
Partitioning enables you to decompose very large tables and indexes into smaller and more manageable pieces called partitions. Each partition is an independent object with its own name and optionally its own storage characteristics.
Partitioning offers these advantages:
Partitioning enables you to decompose very large tables and indexes into smaller and more manageable pieces called partitions. Each partition is an independent object with its own name and optionally its own storage characteristics.
Partitioning offers these advantages:
- Increased availability of mission-critical databases if critical tables and indexes are divided into partitions to reduce the maintenance windows, recovery times, and impact of failures.
- Easier administration of schema objects reducing the impact of scheduled downtime for maintenance operations.
- Reduced contention for shared resources in OLTP systems
- Enhanced query performance: Often the results of a query can be achieved by accessing a subset of partitions, rather than the entire table. For some queries, this technique (called partition pruning) can provide order-of-magnitude gains in performance.
Relevant Links
Overview of Partitioning:
Document 1390871.1 Purpose and Benefits/Advantages/Uses of Table Partitioning
Oracle ® Database Concepts 11g Release 2 (11.2) Part Number E16508-05 Chapter 4
Oracle ® Database VLDB and Partitioning Guide 11g Release 2 (11.2) Part Number E16541-08
Install partitioning option
Document 1312416.1 Common Questions On The Partitioning Option Installed In the Oracle Database
Document 118265.1 How Partitioning Option Gets Installed and How To Verify Installation
Document 434743.1 Can The Partitioning Option Be De-installed When System Partitioned Objects Are Used
Document 430239.1 How To De-install Partitioning Option From Enterprise Edition?
Document 430239.1 How To De-install Partitioning Option From Enterprise Edition?
Verify and enable/disable if needed the partitioning option
Document 1069015.1 How to determine enabled/disabled components in an 11.2 software-only installation
Document 948061.1 How to Check and Enable/Disable Oracle Binary Options
Document 948061.1 How to Check and Enable/Disable Oracle Binary Options
Relevant articles regarding partitions creation and maintenance:
Document 69715.1 Creating & Adding Table and Index Partitions
Document 165303.1 Examples about Insert into Range Partitioned Tables
Document 164874.1 Example of Script to Create a Range Partition Table
Document 166652.1 Example of Script to Maintain Range Partitioned Table
Document 733311.1 Examples For Creating Partitioned table With Different Partitioning Strategies
Document 149116.1 Oracle9i Partitioning Enhancements, LIST Partitioning
Document 209368.1 Range List Partitioning - Oracle 9.2 Enhancement
Document 276158.1 Partitioning Enhancements in Oracle 10g
Relevant articles regarding latest features:
Document 452447.1 11g Partitioning Enhancements
Document 785462.1 11g New Features:System Partitioning
Document 805976.1 11g New Features:INTERVAL PARTITIONING
Document 943567.1 11g new feature: Extended Composite Partitioning (Overview, Example and Use)
Document 761251.1 Oracle 11G Reference Partitioning examples
Document 466352.1 11g Feature: Interval Partitioning Example
Document 757754.1 Interval Partitioning By Week
Relevant articles regarding partition pruning:
Document 179518.1 Partition Pruning and Joins
Document 166118.1 Partition Pruning/Elimination (This article provide a very detailed example of how to identify which partitions/subpartitions were accessed during an execution of a statement using event 10128)
How-To Section
How to Partition a Non-partitioned Table
Document 1563143.1 How Should I Partition My Tables?
Document 1070693.6 How to Partition a Non-partitioned Table
Document 472449.1 How To Partition Existing Table Using DBMS_Redefinition
'How to' relevant articles for partitioning types
Document 854332.1 How To Introduce Interval Partitioning into a Range Partitioned Table
Document 1479115.1 Common Questions On Interval Partitioning
Document 165701.1 How to Implement Hash Partitioning on IOT Tables in 9i & Above
Document 472449.1 How To Partition Existing Table Using DBMS_Redefinition
'How to' relevant articles for partitioning types
Document 854332.1 How To Introduce Interval Partitioning into a Range Partitioned Table
Document 1479115.1 Common Questions On Interval Partitioning
Document 165701.1 How to Implement Hash Partitioning on IOT Tables in 9i & Above
Document 1266993.1 How To Use Multicolumn Partitioning Keys
Document 1480213.1 Multicolumn Partitioning Keys: algorithm based on which the inserts are made
Document 74181.1 Partitioning Tables with User-Defined Types and LOBs
Document 1304370.1 How to use Partition Names for ref partitioning tables when Split is used
Document 846405.1 How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition
HOW TO 12C section
Document 1519042.1 How to Create Interval-Reference Partitioned Tables in Oracle 12c
Document 1482264.1 How to Drop/Truncate multiple partitions in Oracle 12C
Document 1482263.1 How to Merge multiple partitions in Oracle 12C
Document 1482230.1 Splitting a Partition into multiple partitions in Oracle 12C
Document 1482456.1 Adding multiple partitions in Oracle 12C
Document 1482264.1 How to Drop/Truncate multiple partitions in Oracle 12C
Document 1482263.1 How to Merge multiple partitions in Oracle 12C
Document 1482230.1 Splitting a Partition into multiple partitions in Oracle 12C
Document 1482456.1 Adding multiple partitions in Oracle 12C
'How to' relevant articles for partitioned indexes:
Document 69374.1 Partitioned Indexes: Global, Local, Prefixed and Non-Prefixed
Document 74224.1 How to Create Primary Key Partitioned Indexes
Document 795854.1 How To Update Both Global and Local Indexes when Moving Table Partition?
12C section
Document 1482460.1 How to create Partial Global Indexes for Partitioned tables in Oracle 12c
'How to' relevant articles for statistics collection when partitions are used:
Document 175258.1 How to Compute Statistics on Partitioned Tables and Indexes
Document 237538.1 How to Move from ANALYZE to DBMS_STATS on Partitioned Tables - Some Examples
Document 111990.1 ORA-14508: ANALYZE PARTITION TABLE VALIDATE STRUCTURE CASCADE
Document 1050294.1 STALE_STATS OF SUB PARTITION INDEX REPORTED INCORRECTLY IN DBA_TAB_STATISTICS
Document 1302628.1 Collect statistics for a large partitioned table takes a lot when incremental is used
Document 1319225.1 Collect incremental statistics for a large partitioned table in versions 10.2 and 11
Document 1417133.1 Statistics collection on partitioned tables for 10.2 and 11g
'How to' relevant articles for statistics collection when partitions are used:
Document 175258.1 How to Compute Statistics on Partitioned Tables and Indexes
Document 237538.1 How to Move from ANALYZE to DBMS_STATS on Partitioned Tables - Some Examples
Document 111990.1 ORA-14508: ANALYZE PARTITION TABLE VALIDATE STRUCTURE CASCADE
Document 1050294.1 STALE_STATS OF SUB PARTITION INDEX REPORTED INCORRECTLY IN DBA_TAB_STATISTICS
Document 1302628.1 Collect statistics for a large partitioned table takes a lot when incremental is used
Document 1319225.1 Collect incremental statistics for a large partitioned table in versions 10.2 and 11
Document 1417133.1 Statistics collection on partitioned tables for 10.2 and 11g
Troubleshooting Section
Relevant bulletin articles for partitioning related issues:
Document 209070.1 Partition Pruning based on Joins to Partitioning Criteria Stored in Dimension Tables
Document 378138.1 What to check when the fast split partitioning does not appear working?
Document 232628.1 Fast Split partitioning in 9iR2
Relevant articles for troubleshooting import slow issues with partitioning
Document 1073195.1 Data Pump Import (Impdp) slow when importing partitioned table
Document 752904.1 DataPump Export of Partitioned Table is Very Slow and Apparently Hangs
Document 1224663.1 IMPDP Raises ORA-39001, ORA-39203 When Importing A Partition Of A Partitioned Table Over A Network Link
Others
Document 1281826.1 What Types of Partitioning Are Eligible for Partition Change Tracking (PCT) Fast Refresh?
Document 209070.1 Partition Pruning based on Joins to Partitioning Criteria Stored in Dimension Tables
Document 378138.1 What to check when the fast split partitioning does not appear working?
Document 232628.1 Fast Split partitioning in 9iR2
Relevant articles for troubleshooting import slow issues with partitioning
Document 1073195.1 Data Pump Import (Impdp) slow when importing partitioned table
Document 752904.1 DataPump Export of Partitioned Table is Very Slow and Apparently Hangs
Document 1224663.1 IMPDP Raises ORA-39001, ORA-39203 When Importing A Partition Of A Partitioned Table Over A Network Link
Others
Document 1281826.1 What Types of Partitioning Are Eligible for Partition Change Tracking (PCT) Fast Refresh?
Known issues
Document 165599.1 Top Partitioned Tables Issues
Document 199623.1 Top Issues Encountered Regarding Split Partition
Document 166215.1 Top Partition Performance Issues
Document 372357.1 Fast Split Partitioning Not Occurring When It Was Expected
Document 272312.1 How to Recreate a Table Partition After Having Dropped the Datafile?
Document 959116.1 Interval Partitioning Does Not Inherit Logging
Document 198120.1 Exchange Partitions - Common Problems
Document 1401064.1 Common Questions and Errors on Partition Operations Involving Tablespaces of Different Block Sizes
Document 1077819.1 PARTITIONED TABLE: CHANGE IN BUFFER_POOL FOR A PARTITION NEEDS A REBOUNCE
Relevant article to handle various errors:
Document 1395403.1 Master Note for Most Frequent Errors during Partition operations
Document 887659.1 Getting ORA-01410 for Partitioned Tables Without Any Apparent DDL On The Partitions.
Document 1081230.1 INTERVAL RANGE Partition Giving ORA-14400
Document 389804.1 Range Partition Splitting Fails with ORA-01882
Document 405922.1 ORA-07445 [evaopn2] Query With Bit Mapped Indexes And Partitioning
Document 1084542.1 Ora-600 Internal Error Code, Arguments: [Kkedsamp: Bad Partitioning Info.], [1290], [663],
Document 1050966.1 ORA-14652 When Using Reference Partitioning
Document 784989.1 ORA-600 [kdblGetRDBA] During Create Table with Compression and Partitioning
Document 790630.1 ORA-600 [Kkpamdgspam1] When Joining Partitioned Tables at Different Partitioning Levels
Document 727306.1 Ora-14074 When Trying To Add Partition
Document 1389394.1 ORA-1476 DURING GATHER_TABLE_STATS FOR PARTITION WITH GRANULARITY = APPROX_GLOBAL
Dictionary issues introduced with partitioning
Document 1289275.1 OBJ$-PARTOBJ$-TABPART$ mismatch - Dictionary Inconsistency reported for Interval Range Partition Tables
Relevant article to handle size for partitioning
Document 729149.1 Table/Index (partition) Growth Is Far More Than Expected
Document 199623.1 Top Issues Encountered Regarding Split Partition
Document 166215.1 Top Partition Performance Issues
Document 372357.1 Fast Split Partitioning Not Occurring When It Was Expected
Document 272312.1 How to Recreate a Table Partition After Having Dropped the Datafile?
Document 959116.1 Interval Partitioning Does Not Inherit Logging
Document 198120.1 Exchange Partitions - Common Problems
Document 1401064.1 Common Questions and Errors on Partition Operations Involving Tablespaces of Different Block Sizes
Document 1077819.1 PARTITIONED TABLE: CHANGE IN BUFFER_POOL FOR A PARTITION NEEDS A REBOUNCE
Relevant article to handle various errors:
Document 1395403.1 Master Note for Most Frequent Errors during Partition operations
Document 887659.1 Getting ORA-01410 for Partitioned Tables Without Any Apparent DDL On The Partitions.
Document 1081230.1 INTERVAL RANGE Partition Giving ORA-14400
Document 389804.1 Range Partition Splitting Fails with ORA-01882
Document 405922.1 ORA-07445 [evaopn2] Query With Bit Mapped Indexes And Partitioning
Document 1084542.1 Ora-600 Internal Error Code, Arguments: [Kkedsamp: Bad Partitioning Info.], [1290], [663],
Document 1050966.1 ORA-14652 When Using Reference Partitioning
Document 784989.1 ORA-600 [kdblGetRDBA] During Create Table with Compression and Partitioning
Document 790630.1 ORA-600 [Kkpamdgspam1] When Joining Partitioned Tables at Different Partitioning Levels
Document 727306.1 Ora-14074 When Trying To Add Partition
Document 1389394.1 ORA-1476 DURING GATHER_TABLE_STATS FOR PARTITION WITH GRANULARITY = APPROX_GLOBAL
Dictionary issues introduced with partitioning
Document 1289275.1 OBJ$-PARTOBJ$-TABPART$ mismatch - Dictionary Inconsistency reported for Interval Range Partition Tables
Relevant article to handle size for partitioning
Document 729149.1 Table/Index (partition) Growth Is Far More Than Expected
Additional Resources
White Papers
Partitioning with Oracle Database 11g Release 2 (September 2009)
Partitioning in Oracle Database 11g (June 2007)
Partitioning White papers are also accessible via Note 1329441.1
Partitioning in Oracle Database 11g (June 2007)
Partitioning White papers are also accessible via Note 1329441.1
Community Discussions
Still have questions? Use the communities window below to search for similar discussions or start a new discussion on this subject.
Note: Window is the live community not a screenshot.
Click here to open in main browser window.
Note: Window is the live community not a screenshot.
Click here to open in main browser window.
REFERENCES
NOTE:1302628.1 - Collect Statistics for a Large Partitioned Table is Slow When Incremental Option Is UsedNOTE:1073195.1 - DataPump Import (IMPDP) Is Slow When Importing Partitioned Tables
NOTE:1077819.1 - Changing Buffer_pool for a Partitioned Table Requires Database to be Bounced
NOTE:179518.1 - Partition Pruning and Joins
NOTE:1070693.6 - How to Partition a Non-partitioned / Regular / Normal Table
NOTE:198120.1 - Exchange Partitions - Common Problems
NOTE:1081230.1 - INTERVAL RANGE Partition Giving ORA-14400
NOTE:1266993.1 - How To Use Multicolumn Partitioning Keys
NOTE:1084542.1 - Ora-600 Internal Error Code, Arguments: [Kkedsamp: Bad Partitioning Info.], [1290], [663]
NOTE:209070.1 - Partition Pruning Based on Joins to Partitioning Criteria Stored in Dimension Tables
NOTE:209368.1 - Range List Partitioning - Oracle 9.2 Enhancement
NOTE:74181.1 - Partitioning Tables with User-Defined Types and LOBs
NOTE:74224.1 - How to Create Primary Key Partitioned Indexes
NOTE:1389394.1 - Ora-1476 When Collecting Statistics On Empty Table with Granularity = Approx_Global
NOTE:1395403.1 - Master Note for Most Frequent Errors during Partition operations
NOTE:69715.1 - Example for Creating And Adding Table and Index Partitions To Ranged Partitioned Table
NOTE:272312.1 - How to Recreate a Table Partition After Having Dropped the Datafile?
NOTE:175258.1 - How to Compute Statistics on Partitioned Tables and Indexes (9iR2 and prior)
NOTE:199623.1 - Top Issues Encountered Regarding Split Partition
NOTE:466352.1 - 11g Feature: Interval Partitioning Example
NOTE:752904.1 - DataPump Export Of Partitioned Table Is Very Slow And Apparently Hangs
NOTE:785462.1 - 11g New Features: System Partitioning
NOTE:372357.1 - Fast Split Partitioning Not Ocurring When It Was Expected
NOTE:1329441.1 - White Papers for Data Warehousing Components in the Oracle Database
NOTE:276158.1 - Partitioning Enhancements in Oracle 10g
NOTE:790630.1 - ORA-600 [Kkpamdgspam1] When Joining Partitioned Tables at Different Partitioning Levels
NOTE:846405.1 - How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition
NOTE:795854.1 - How To Update Both Global and Local Indexes when Moving Table Partition?
NOTE:805976.1 - 11g New Features:INTERVAL PARTITIONING
NOTE:164874.1 - Example of Script to Create a Range Partition Table
NOTE:165701.1 - How to Implement Hash Partitioning on IOT Tables in 9i & Above
NOTE:166118.1 - How to see Partition Pruning Occurred?
NOTE:166215.1 - Top Partition Performance Issues
NOTE:166652.1 - Example of Script to Maintain Range Partitioned Table
NOTE:472449.1 - How To Partition Existing Table Using DBMS_Redefinition
NOTE:757754.1 - Interval Partitioning By Week
NOTE:761251.1 - Reference Partitioning Examples in Oracle 11G and above
NOTE:378138.1 - What to check when the fast split partitioning does not appear as working?
NOTE:1390871.1 - Purpose and Benefits/Advantages/Uses of Table Partitioning
NOTE:389804.1 - Range Partition Splitting Fails with ORA-01882
NOTE:165303.1 - Examples about Insert into Range Partitioned Tables.
NOTE:165599.1 - Top Partitioned Tables Issues
NOTE:1319225.1 - Collect Incremental Statistics For a Large Partitioned Table in 10g and in 11g
NOTE:1304370.1 - How to use Partition Names for ref partitioning tables when Split is used
NOTE:1417133.1 - How To Collect Statistics On Partitioned Table in 10g and 11g
NOTE:729149.1 - Table/Index (partition) Growth Is Far More Than Expected
NOTE:727306.1 - Ora-14074 When Trying To Add Partition
NOTE:430239.1 - How To De-install Partitioning Option From Enterprise Edition?
NOTE:434743.1 - Can The Partitioning Option Be Deinstalled When System Partitioned Objects Are Used
NOTE:452447.1 - 11g Partitioning Enhancements
NOTE:1289275.1 - OBJ$-PARTOBJ$-
NOTE:854332.1 - How To Introduce Interval Partitioning into a Range Partitioned Table
NOTE:111990.1 - ORA-14508: ANALYZE PARTITION TABLE VALIDATE STRUCTURE CASCADE
NOTE:1224663.1 - DataPump Import (IMPDP) Raises Errors ORA-39001 ORA-39203 When Importing A Partition Over A Network Link
NOTE:1281826.1 - What Types of Partitioning Are Eligible for Partition Change Tracking (PCT) Fast Refresh?
NOTE:784989.1 - ORA-600 [kdblGetRDBA] During Create Table with Compression and Partitioning
NOTE:69374.1 - Partitioned Indexes: Global, Local, Prefixed and Non-Prefixed
NOTE:1479115.1 - Interval Partitioning Essentials - Common Questions - Top Issues
NOTE:232628.1 - Fast Split partitioning in 9iR2
NOTE:237538.1 - How to Move from ANALYZE to DBMS_STATS on Partitioned Tables - Some Examples
NOTE:887659.1 - Getting ORA-01410 for Partitioned Tables Without Any Apparent DDL On The Partitions.
NOTE:943567.1 - 11g new feature: Extended Composite Partitioning (Overview, Example and Use)
NOTE:959116.1 - Interval Partitioning Does Not Inherit Logging
NOTE:1312416.1 - Common Questions on the Partitioning Option Installed in the Oracle Database (Licensing, Install, Remove)
NOTE:1050294.1 - Stale_Stats of Sub Partition Index Reported Incorrectly in Dba_Tab_Statistics
NOTE:1050966.1 - ORA-14652 When Using Reference Partitioning
NOTE:149116.1 - Oracle9i Partitioning Enhancements, LIST Partitioning.
NOTE:1401064.1 - Common Questions and Errors on Partition Operations Involving Tablespaces of Different Block Sizes
NOTE:1482460.1 - How to Create Partial Global/Local Indexes for Partitioned Tables in Oracle 12c
NOTE:1519042.1 - How to Create Interval-Reference Partitioned Tables in Oracle 12c
NOTE:1482264.1 - How to Drop/Truncate Multiple Partitions in Oracle 12C
NOTE:1482263.1 - How to Merge Multiple Partitions in Oracle 12C
NOTE:1482230.1 - Splitting a Partition Into Multiple Partitions in Oracle 12C
NOTE:1482456.1 - How to Add Multiple Partitions in Oracle 12C
NOTE:1681857.1 - Example of Script to Create a Composite HASH-HASH Partitioned Table
Comments
Post a Comment
Oracle DBA Information