Database DataWarehousing (MOSC)

MOSC Banner

Any extra step after direct path insert to partitioned IOT

edited Aug 6, 2015 10:05AM in Database DataWarehousing (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center