Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to partition sequence values for interval partitioning?

supersenAug 26 2013 — edited Jan 27 2015

HI gurus,

Please help me on this. I am going to partition the table based on number column DATASEQ (number 20)

when each time the table updated, it will have new sequence value in DATASEQ. it is need to be partitioned. i decided to go for INTERVAL partitioning .

PARTITION BY RANGE (DATASEQ)

INTERVAL(1)

(PARTITION P1 VALUE LESS THAN

)

will it be good for partitioning the sequence?

Pls help

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2013

Added on Aug 26 2013

#general-database-discussions

8 comments

4,077 views