Data Tablespace Name

Database Connection and Account Details Menu

Description

The tablespace in which to create the iProcess Engine database schema.

Note 

For Oracle users, you can either create this account before you run the installer, let the installer create it for you, or create it after you have run the installer. See How Do I Decide Which Oracle Database Creation Method to Use.

Value

 

Installation Type

New Installation

Upgrade Installation

Value

A name that:

—is between 1 and 30 characters long.

—contains only lowercase, alphanumeric, and underscore (_) characters.

—has a leading alphanumeric character.

The name of the existing default database tablespace, taken from the $SWDIR/etc/tablespace file.

You cannot change this value.

Default Value

STAFFWAR

Node Cluster

If you are installing a slave server, the tablespace name used must be the same name used on the master server.

Notes

This menu item is not displayed if you are upgrading an existing iProcess Engine.

By default, all iProcess Engine tables, indexes, and Oracle AQ queues are stored in this tablespace.

If you are using pre-created multiple tablespaces (see Change the Default Data or Temporary Tablespace), you should specify the name of one of the pre-created tablespaces.

If you are using Oracle Real Application Clusters (RAC) you must create all required tablespaces on the RAC shared storage device before running the installer. If you do not do this, the installer creates the data file for the tablespace in the $ORACLE_HOME/dbs directory.

If the tablespace you specify does not already exist, you are prompted to create it when you continue from the Oracle Database Connection and Account Details Menu. For example:

Data Tablespace Name (sw961) does not exist
create Tablespace (Y/N - default N): Y

If you enter:

• N, the menu is re-displayed and the old name is shown.
• Y, the tablespace is flagged for creation and you are prompted to enter two further pieces of information:

the tablespace size. For example:

Enter size (in Mb) for tablespace sw961 [default: 50 Mb]:

Either enter a value or press ENTER to accept the default value.

the tablespace location. For example:

Enter location for tablespace sw961 files [default "" ]:

Either enter a directory name or press ENTER key to accept the default location, which is $ORACLE_HOME/dbs.

Note 

The tablespace is not actually created until the installer performs the installation. See step 7 in Installing TIBCO iProcess Engine in Console Mode. The name of the database tablespace is saved in the $SWDIR/etc/tablespace file.

See Also

Configuring the Oracle Schema

Control File Keyword

IPEI_DBTABLESPC