Database Administration (MOSC)

MOSC Banner

interval partitioning on a number column

edited Feb 27, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

Hi ,

I have got a requirement for interval partitioning of a column which contains date whose data type is number .

I have asked to do a partitioning for 3 months .Can anyone get me a syntax for doing it .Thanks in advance .

I tried the below syntax .But was not able to get partitioning for 3 months .

create table test

( prod_id number,

   prod_code varchar2(3),

   release_date number

)

partition by range(release_date)

interval(300)

(partition empty values less than (20000301) )

/

Regards,

Nash

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