Top Issues Encountered Regarding Split Partition
(Doc ID 199623.1)
Last updated on AUGUST 18, 2020
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?
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
13. SPLIT PARTITION FROM YEARLY TO MONTHLY
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!