Search notes:

ORA-14767: Cannot specify this interval with existing high bounds

An interval partitioned table whose intervals depend on a date value and are multiple of months (numtoyminterval(x, 'month') must not have a day greater than 28, otherwise, Oracle throws an ORA-14767: Cannot specify this interval with existing high bounds error, as shown with the following attempt to create a table:
create table tq84_tab_part (
   dt   date,
   val  number,
   txt  varchar2(20)
)
partition
   by range (dt)
      interval (numtoyminterval(1, 'month'))
   (
      partition p_start values less than (date '2019-12-31' )
--    partition p_start values less than (date '2020-01-01' )
   )
;
The following statement creates the table.
create table tq84_tab_part (
   dt   date,
   val  number,
   txt  varchar2(20)
)
partition
   by range (dt)
      interval (numtoyminterval(1, 'month'))
   (
--    partition p_start values less than (date '2019-12-31' )
      partition p_start values less than (date '2020-01-01' )
   )
;
Cleaning up
drop   table tq84_tab_part;

See also

Other Oracle error messages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759473920, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-14767_cannot-specify-this-interval-with-existing-high-bounds(69): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78