Database DataWarehousing (MOSC)

MOSC Banner

Partition for Fact table

edited Aug 10, 2020 11:12AM in Database DataWarehousing (MOSC) 4 commentsAnswered

Dear All,

I would like to create a partition for the below fact table. Date_id has been stored in the Dimension table as 'yyyymmdd' and this is Primary key. In Fact table I am using below command to create partitions. Is it OK to proceed as below and expect suggestion to proceed.

CREATE TABLE FACT_TST1(

REC_ID NUMBER(13) constraint PKRECID_FCTTST PRIMARY KEY,

REC_VALUE number(7,3),

DATE_ID date,

TM_ID number(8),

TP_ID number(8),

SC_ID number(10),

PR_ID number(10),

LAST_UPDATED timestamp)

PARTITION BY RANGE (DATE_ID)

INTERVAL(numtoyminterval(1, 'MONTH'))

(PARTITION p_old_data VALUES LESS THAN (TO_DATE('2020-08-08', 'YYYY-MM-DD')));

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