Database DataWarehousing (MOSC)

MOSC Banner

interval partition on number data type

edited Apr 22, 2010 11:33AM in Database DataWarehousing (MOSC) 3 commentsAnswered
Hi,
I got some issues for defining an interval partition table on a numeric column,  any help will be very much appreciated.

Say we have a table, which is sort of periodic fact table, we want to use interval partition on the column PERIOD_DATE_KEY. What's stored in this field is a number format for a date, say if the date is Jan-31-2010, the value in the field is 20100131 as a number.
The interval for this table is one month. See the table below.
 
SALES_INTERVAL_MONTH_T1
(
 PERIOD_DATE_KEY      NUMBER(10),  -- date in a format of to_number(to_char(to_date('20100120','yyyymmdd'),'yyyymmdd'))

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