Previous Topic

Next Topic

Book Contents

Multiple trial tablespaces

By default, all trial objects are created in the INFORM tablespace. In production, you should distribute each trial across multiple tablespaces for improved performance and for maintenance and monitoring. Before you install your trial on a production server, set up the trial-specific tablespaces.

The following table lists the Oracle table and index tablespaces to create, along with the required parameters. All tablespaces should be locally managed.

Tablespace

Size (GB)

INFORM

1

<TRIAL Name>

1

<TRIAL Name>_LOB

1

The remaining syntax for each of these tablespaces is:

AUTOEXTEND ON NEXT 50M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Note: The TRIAL_NAME portion of the tablespace name must conform to Oracle name standards. It cannot start with a numeric character and cannot contain special characters. Additionally, because the Oracle software has an internal limitation of 30 characters for a tablespace name, the trial name must be 16 characters or fewer.

Oracle provides sample configurations for distributing your tablespaces using one disk to five disks.

Send Feedback