Database DataWarehousing (MOSC)

MOSC Banner

Can/should I pre-create tablespaces for range partitioning?

edited May 1, 2012 10:59PM in Database DataWarehousing (MOSC) 6 commentsAnswered
Hi, I am setting up a database and 5 of the largest tables are to be partitioned.  I am proposing to use one large tablespace for the whole 'data' section of the database as the data is to be stored on a SAN.  With one of the tables I need to partition based on a date (createdate).  My problem is that if I partition based on range, the new partions are not automatically created, whereas if I use interval partitioning this will mean that one of the indexes I have must be a global index, hence if I delete records

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