Any extra step after direct path insert to partitioned IOT
hi
I have an IOT which is partitioned into 8 partitions.
I need to migrate a large amount of data - 3.5 billion rows - from one partitioning method to another.
I intend to insert into the new table in ordered sets that match the IOT order using direct path ( APPEND ) and NOLOGGING, followed by a data reconciliation of old to new.
Is there anything I need to do after the population to ensure that the lack of redo does not jeapordise table/index structure consistency.
thanks
Rod
Database 11gr2 enterprise