Database DataWarehousing (MOSC)

MOSC Banner

Partitioned table

edited Sep 24, 2014 9:14AM in Database DataWarehousing (MOSC) 6 commentsAnswered
I would appreciate advice on a large composite-partitioned table.  The database version is 11.2. 

 

The partitions are by range on a date column, and there is one partition for each month.  After the month is over, there will be no further inserts.  There are never any updates on this table.  Retention of this data is five years, and records be removed by the partition

 

The subpartitions are by hash on an “ID” column that is defined as varchar2(64).   There are 8 subpartitions for each partition, stored in three tablespaces.  The underlying datafiles for these tablespaces are on two disks.

 

There is a primary key constraint on the table (date + id), using a local index.

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