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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Partition by numeric month with auto-intervals?

JorgeGarciaMXSep 26 2017 — edited Sep 27 2017

Hello,

We have 12c on our server, we have a requeriment to create partitioned tables for our monthly sales fact tables but our columns are numeric based instead of date datatype.

For example we have:

CREATE TABLE SALES (
month_id integer,
sales_rep_id integer,
sales numeric(18,4) )

Our month_id filelds are 201701, 201702...201712

Is there a way to create partition intervals (to take the advantadge of automatic partitioning) with this range?

Any help is appreciated.

Thanks!

This post has been answered by Mustafa KALAYCI on Sep 26 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2017

Added on Sep 26 2017

#12c, #general-database-discussions

8 comments

1,148 views