Partitioning question

From: Dimitry Vargalyuk <dimonvv_at_ua.fm>
Date: Wed, 13 Feb 2002 17:46:39 +0200
Message-ID: <3C6A8A5E.DC6B1375@ua.fm>

I have db schema as following:

CREATE TABLE EVENTS (

  ID          NUMBER (14)   NOT NULL,
  EVENTTIME      DATE          NOT NULL,

... blah blah ...

  CONSTRAINT EVENTS_PK
  PRIMARY KEY ( ID ) ) ; CREATE TABLE CHARGES (
  EVENT NUMBER (14) NOT NULL,
... blah blah ...

  ) ;

ALTER TABLE CHARGES ADD CONSTRAINT CHARGES_EVENT_ID  FOREIGN KEY (EVENT)
  REFERENCES EVENTS (ID) ; I want to create range partitions on EVENTS table on EVENTTIME column. Each partition will contain data for one month. Also I need the same partitioning on CHARGES table. Should I copy EVENTTIME column to CHARGES table or there are another ways?

Best regards,
Dimitry. Received on Wed Feb 13 2002 - 09:46:39 CST