RelationalDBDesign RelationalDBDesign 


Partitioned Tuning   «Prev  Next»

Create a Partitioned Table - Exercise

Objective: Create a partitioned table.

Scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the

Submit

button to receive full credit.

Instructions


You are creating a data warehouse to track the number of telephone calls for a telecommunications company. The design team has created the following table definition:

This is the sql code to define a table
This table will receive 100,00 rows per day. In order to manage this database, you want to partition the table so that each partition contains the data from each month. When the month changes, the new data will be placed into a new tablespace. You need to define partitions for January 2000 through March 2000 and you will use the tablespace ts_jan_2000, ts_feb_2000, and ts_mar_2000 to hold the values.

Hints


Remember your data manipulation functions for dates.