Database DataWarehousing (MOSC)

MOSC Banner

interval partition/range partition question

edited Jun 22, 2015 2:07AM in Database DataWarehousing (MOSC) 4 commentsAnswered

Hello,

I am new to partitoins and have question need help.

Basically my goal is to setup period column with either intever partition or range partition scheme which most suitable to my data below.

The period column have year(2014,2015,2016) and accounting period(001,002,003 combination (2014001)

Period

2014001

2014002

2014003

2014004

....

...

2015001

...

What will be syntax for partitoin table create  if  I would like to setup interval partition ? If interval not possible then what will be syntax for range ?

I tried below but not working -

create table test(period number(15) not null)

partiton by list(period) interval(numtoyminterval(001,'MONTH')

(partiton part_1  values less than 2014002

....

It's giving me error - invalid option ...

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