Database DataWarehousing (MOSC)

MOSC Banner

unexpected use of TEMP ts in direct path insert of IOT

edited Aug 11, 2015 10:07AM in Database DataWarehousing (MOSC) 16 commentsAnswered

hi again folks

I am migrating 3.5 billion rows from an IOT hash partitioned to an IOT range partitioned.

The data and table layout remain the same.

As an alternative trial I ran the following - all names are only for demonstration

table_b is empty and all partitions have been pre-created for the data range in table_a

The reason for the order by was to indicate that the resulting data would be in the same order as the destination IOT

insert /*+ APPEND NOLOGGING */

into table_b

  (  pk_number_value,

     pk_timestamp_value,

     timestamp_value,

     number_value

  )

select /*+ PARALLEL(2) */

     a.pk_number_value,

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