RE: Manually Creation of an Interval partition

Insert and rollback (or commit and truncate) a row for each relevant interval you need?  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: Wednesday, July 03, 2019 9:44 AM
To: ORACLE-L
Subject: Manually Creation of an Interval partition  

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