Database Administration (MOSC)

MOSC Banner

Convert to Interval Partition from Range partition in 11g

edited Dec 12, 2013 9:23PM in Database Administration (MOSC) 4 commentsAnswered ✓
Hi,

We have some tables with range partition in Oracle version 11.2.0.3.0.

We want to convert them to Interval partition so as to avoid yearly manual partition creation.

The current structure of range partition:

PARTITION BY RANGE (AS_OF_DATE)

  PARTITION P201109 VALUES LESS THAN (TO_DATE(' 2011-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
..
..
)

Can we safely issue below statement:

alter table owner.table_name  set INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'));

and convert the table to Interval partition? What is the 'NLS_CALENDAR=GREGORIAN' option in Range partition clause? Is it safe to modify it to Interval partition directly?

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