Manually Creation of an Interval partition

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 3 Jul 2019 08:43:43 -0500
Message-ID: <CAJvnOJYDCRgpymQpP5iqNuJz8pqKrvTVPY0GG+=Adg14uQN1GA_at_mail.gmail.com>

I was doing some work with dbms_redefinition on a very large interval partitioned table, and ran into a problem whereby the new interval partition was created during the copy table dependents process. this caused the copy_table_dependents procedure to error out.

I could avoid this by forcing the creation of the new interval partition on both the interim table and the existing table prior to the dbms_redefinition process, but I am not sure how to force the creation of the new interval partition. Is it possible to do this without switching to manual partition creation entirely? I dont use partitioning a lot, so I am not fully familiar with all the bugs and features (is there a difference?).

Oracle 12.1.0.2 on Linux x86-64.

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 03 2019 - 15:43:43 CEST