![]() *Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575 ORA-14300: partitioning key maps to a partition outside maximum permittedġ4300, 00000, "partitioning key maps to a partition outside maximum permitted number of partitions" ![]() Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionĢ partition by range (id) interval (5000)Ħ select object_id, object_name, created from dba_objects Last Successful login time: Fri 09:07:55 +02:00 As always, if you are following along, make sure you are appropriately licensed for this feature The SituationĬonsider the following example: SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 16 09:32:17 2019Ĭopyright (c) 1982, 2019, Oracle. ![]() ![]() This time I decided to write about it so I don’t have to spend 5 minutes rediscovering the wheel. While researching interval partitioning in Oracle 19c I came across a phenomenon I had already solved a long time ago but then forgot about. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |