Database Administration (MOSC)

MOSC Banner

Split partition with minimal logging

edited Jan 26, 2014 8:10PM in Database Administration (MOSC) 2 commentsAnswered
We're having trouble splitting an overflow partition and need some creative solutions.
The table has 2 BLOBS.  The overflow partition has the following #rows by date which we want to split by date.

  COUNT(*) TRUNC(CREATION_T

---------- ----------------

    901163 2014-01-17 00:00

    765602 2014-01-18 00:00

    655657 2014-01-19 00:00

    862829 2014-01-20 00:00

    991540 2014-01-21 00:00

    944803 2014-01-22 00:00

    945059 2014-01-23 00:00

    904564 2014-01-24 00:00

    580013 2014-01-25 00:00

If we turn off logging at the table level will that turn off logging of the split at the partition level?

thanks,
Janet

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