Creating a Tablespace

The function Create tablespace is used to create new tablespaces. SAPDBA only supports the creation of tablespaces that correspond to the naming conventions for SAP tablespaces (PSAP<name>D/I). PSAPROLL and PSAPTEMP can also be created with SAPDBA, but not tablespace SYSTEM.

When you create a tablespace, SAPDBA verifies that the corresponding data and index tablespaces already exist. The results of the check are displayed, but any missing tablespaces are not created automatically. You must ensure that both the data tablespace and the index tablespace exist.

Specify the name of the tablespace. Then select Create tablespace <tablespace name>. The following menu options appear, depending on whether you want to assign a file (in file system) or a raw device (on raw device) to the tablespace.

Create new tablespace <tablespace name>

Corresponding <index/data> tablespace <tablespace name> exists/does not exist

 

File system

Raw devices

a -

File system or raw device

File system or raw device
New data file name/Required raw device name

b -

File size

Enter raw device name

c -

Select sapdata path

Select raw device in path

d -

Alter suggested path

File size on raw device

e -

Default storage parameters

 

s -

Start (create tablespace)

Start (create tablespace)

q -

Return

Return

File system or raw device: SAPDBA displays whether you are working in a file system (file system) or on raw devices (raw device). You can choose again here between working in the file system or on raw devices. If you are working on raw devices, the ORACLE name of the raw device and the required raw device ID are displayed. See also SAPDBA Support for Raw Device Configuration.

File system:

You can decide which of the displayed sapdata directories you want to create the new tablespace in. Make sure that a data tablespace and its corresponding index tablespace lie in different sapdata directories.

Always use Select path to define the name of the new data file, as this will provide you with additional important information: which directories are available, how much free storage space is available, which directories contain the files of the corresponding tablespaces (if they exist).

See Naming Convention.

You can also specify a different file name. In this case, SAPDBA also checks whether there is sufficient storage space in the file system which was suggested to store the new data file.

Raw Device:

SAPDBA checks whether:

SAPDBA does not check whether the raw device is used by another application or whether the disk is partitioned and the partitions are reserved.

You can decide which of the displayed raw devices you would like to select. SAPDBA informs you if the naming convention does not correspond to the SAP norm. If necessary, change the raw device ID as user root . SAPDBA displays the size of the selected raw device, but it cannot be changed.

Start (create tablespace): Creates the tablespace. SAPDBA generates a log <timestamp>.ext .

In addition to the delivered tablespaces (see SAP Naming Convention: Tablespace Names) SAP currently supports the creation of self-defined tablespaces (PSAPUSER<n>D/I, n<=9). SAPDBA updates the database tables TAORA and IAORA to enable you to create tables and indexes for the new tablespaces you defined from within the R/3 System.