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.'