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!

partition on two columns

J1604Oct 27 2008 — edited Oct 27 2008

Hi
I want to create partitions on two dates by RANGE paritition
dates are service_dt and process_dt these dates are different from each other
when I try using
partition by range(service_dt,process_dt) gave me an error

'ORA-14018: partition bound list contains too few elements'

How shall I specify these two columns in create table statement
so I can have two seperate partitions for each one of them.

any help is highly appreciated.
Thanks in advance
JP

This post has been answered by 448778 on Oct 27 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2008

Added on Oct 27 2008

#general-database-discussions

2 comments

556 views