Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.