My Oracle Support Banner

Top Issues Encountered Regarding Split Partition (Doc ID 199623.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


To provide common errors and issues when splitting a partition.


Common Problems when Splitting a Table Partition

1. What does the SPLIT PARTITION command do?

2. ORA-14011

3. ORA-14080

4. What happens to the indexes when a SPLIT command is issued?

5. ORA-01882 - Range Partition Splitting Fails with ORA-01882

6. ORA-604, ORA-1 When Splitting a Partition

7. Split Partition Fails with ORA-600 [ainPSplit0]

8. Error ORA-00922 While Altering IOT Split Partition

9. Queries Return Wrong Results During Ddl Operations (Move/Split Partition)

10. Split Partition on IOT in Parallel fails with ORA-25182

11. Split Partition Is Losing Nologging Attribute On Index Subpartitions

12. Split Partition On Subparition Templated Table Resulted In System Generated Named Sub-Partitions


14. Bug 7313847 - OERI[ktecgetsh-inc] after shrink and split of partitioned table

15. How to perform a FAST SPLIT PARTITION, using ALTER TABLE.

16. Bug 12678920 - ORA-7445 [kkpobifd_build_idx_frag_descrs] on ALTER TABLE ... split partition ...

17. Split Partition With ANYDATA Datatype Column Signals ORA-14223 Error

18. Splitting a Partition Into Multiple Partitions in Oracle 12C

19. ORA-00406 / ORA-00722


For DBAs and Support Engineers.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.