Partitioned Tuning  «Prev  Next»

Create 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.
SQL code to define a table
create table class
(
call_date	date,
origination_number	number,
designation_number	number,
duration	number
);
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.