Interval partitioning - modify transition point
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Thu, 28 May 2020 17:19:50 +0200
Message-ID: <3b52aa49-618b-f015-976b-bcb8e77b43ee_at_gmail.com>
Hello all,
Date: Thu, 28 May 2020 17:19:50 +0200
Message-ID: <3b52aa49-618b-f015-976b-bcb8e77b43ee_at_gmail.com>
Hello all,
can the transition point (the first partition) of an interval partitioned table be modified in order to avoid the ORA-14299 error?
We have a daily range partitioned table with list subpartitions. We're trying to modify the subpartition template to add new values to the list and we're hitting the error below:
ORA-14299: total number of partitions/subpartitions exceeds the maximum limit
Automatic partition retention is in place, but of course the interval partitioning considers the entire date range from the transition point at table creation until now.
Oracle 11.2.0.3 EE
Best regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 28 2020 - 17:19:50 CEST