English

How To: Configure the ArcSDE DBTUNE for creating a partitioned table in Oracle

Summary

Instructions provided demonstrate how to configure a business table's storage clause for creating a partitioned table in Oracle.

Procedure

The excerpt included in this article is from an ArcSDE DBTUNE file.

The name of the keyword is 'PARTITION', and the only parameter set for defining the business table's storage clause is 'B_STORAGE'.

In the DBTUNE 'PARTITION' keyword example, the storage clause contains the string 'PARTITION BY RANGE (attr_date)', which informs Oracle that the table should be partitioned using the attr_date attribute. Therefore, the objectclass being created must have an attribute named 'attr_date'. The storage clause also contains the name of five partitions: Quarter1, Quarter2, Quarter3, Quarter4 and Qunknown. Each partition is defined to store the rows that have an attr_date attribute value less than the specified date, and each partition contains a storage clause for the initial segment size (128K) and the name of the tablespace.

For example, any row that the attr_date attribute value is less than '09-30-2007' and greater than '06-30-2007' is stored in the Quarter3 partition in the q3 tablespace. Any row that the attr_date attribute is greater than '12-31-2007' is stored in the Qunknown partition in the quarter_unknown tablespace.

Code:
##PARTITION

B_STORAGE "PARTITION BY RANGE (attr_date)
(PARTITION Quarter1 VALUES LESS THAN (to_date('03-31-2007','MM-DD-YYYY'))
STORAGE (INITIAL 128K) TABLESPACE q1,
PARTITION Quarter2 VALUES LESS THAN (to_date('06-30-2007','MM-DD-YYYY'))
STORAGE (INITIAL 128K) TABLESPACE q2,
PARTITION Quarter3 VALUES LESS THAN (to_date('09-30-2007','MM-DD-YYYY'))
STORAGE (INITIAL 128K) TABLESPACE q3,
PARTITION Quarter4 VALUES LESS THAN (to_date('12-31-2007','MM-DD-YYYY'))
STORAGE (INITIAL 128K) TABLESPACE q4,
PARTITION Qunknown VALUES LESS THAN (MAXVALUE)
STORAGE (INITIAL 128K) TABLESPACE quarter_unknown)”
UI_TEXT "Partition keyword for creating partitioned tables."

END

For additional information on partitioning, see the link to Oracle's documentation in the Related Information section below.

See the link to the ArcGIS Desktop Help topic 'DBTUNE configuration keywords' in the Related Information section below for additional information on how to manage the ArcSDE DBTUNE.

Related Information