Database DataWarehousing (MOSC)

MOSC Banner

Subpartition by range with interval per DAY

edited Mar 14, 2013 12:16AM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi All
I want to create a composite(list-range) partition table with subpartition by range (interval per day).

But I'm not sure that interval functionallity works for subpartition tables.

This is the statement:

create table table_partition
(
  campo1 varchar2(100),
  campo2 number,
  estado varchar2(100),
  fecha date
  )
partition by list (estado)
subpartition by range (fecha)
INTERVAL (NUMTODSINTERVAL(1,'DAY'))
(
partition part1 values(0)(subpartition fecha1 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN'))),
partition part2 values(10)(subpartition fecha2 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN'))),
partition part3 values(90)(subpartition fecha3 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN')))

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