Creating a Tablespace with BR*Tools

Context

You can use BR*Tools for Oracle to create a new tablespace.

Note

This section describes how you create a tablespace with BR*Tools.

For more information on the approach to creating a tablespace, see Managing Tablespaces.

Procedure

Start the procedure using BRGUI or BRTOOLS, or from the command line:

BRGUI or BRTOOLS:

Choose Space Management Create tablespace .

BRGUI or BRTOOLS displays the menu BRSPACE options for tablespace extension, where you specify the options with which you call BRSPACE.

Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p\|-profile
Database user/password (user)	-u\|-user
Tablespace name (tablespace)	-f tscreate -t\|-tablespace
Confirmation mode (confirm)	-c\|-confirm
Scrolling line count (scroll)	-s\|-scroll
Message language (language)	-l\|-language
BRSPACE command line (command)	This shows you the BRSPACE -f tscreate command that is to be executed using the current settings.

Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.
Choose Continue to start BRSPACE.

Command line

You need to enter at least the following command:

brspace -f tscreate

You can enter more parameters, including the tablespace name, if required. For more information, see BRSPACE -f tscreate.

Note

Whichever way you start the procedure - with BRGUI or BRTOOLS, or from the command line - you can take advantage of quick mode if you know the object name, in this case the tablespace name. For more information, see How to Use BR*Tools.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.

If you have already entered the tablespace name, continue with step 4 (quick mode).

BRSPACE displays the Tablespace creation main menu.
Choose Create tablespace.

BRSPACE displays the menu Main options for creation of tablespace.

Set the required main options:

Menu Entry	Meaning
Tablespace name (tablespace)	-f tscreate -t\|-tablespace
Tablespace contents (contents)	-f tscreate -c\|-contents
Segment space management (space)	-f tscreate -s\|-space
Database owner of tablespace (owner)	-f tscreate -o\|-owner
Table data class / tabart (class)	-f tscreate -l\|-class
Data type in tablespace (data)	-f tscreate -d\|-data
Joined index/table tablespace (join)	-f tscreate -j\|-join
Uniform size in MB (uniform)	-f tscreate -u\|-uniform
Bigfile tablespace (bigfile)	-f tscreate -b\|-bigfile
Tablespace compression (compress)	-f tscreate -k\|-compress
Tablespace encryption (encryption)	-f tscreate -e\|-encryption
Encryption algorithm (algorithm)	-f tscreate -g\|-algorithm

Note

For more information on naming the new tablespace, see SAP Naming Conventions for Tablespaces and Data Files.

Choose Continue.

BRSPACE displays the menu Space options for creation of tablespace.

Set the required options:

Menu Entry	Meaning
Tablespace file name (file)	Unless you specified it at the command line, BRSPACE automatically enters the file name according to the SAP naming convention. For more information, see -f tscreate -f\|-file.
Raw disk / link target (rawlink)	-f tscreate -r\|-rawlink
File size in MB (size)	-f tscreate -s\|-size
File autoextend mode (autoextend)	-f tscreate -a\|-autoextend
Maximum file size in MB (maxsize)	-f tscreate -m\|-maxsize
File increment size in MB (incrsize)	-f tscreate -i\|-incrsize
SQL command (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

If required, repeat the previous step when prompted by BRSPACE with message BR1091I.

You can add up to five files to the selected tablespace by repeating the previous step.

Note
For the file option, you can enter not only full path names, but also the sapdata path name, sapdata<N>, or just <N> to specify in which sapdata directory the file is to be located. BRSPACE automatically extends the incomplete file name to the full path name according to the SAP naming conventions.

If Data type in tablespace is table, BRSPACE displays the menu Space options for creation of index tablespace.

If Data type in tablespace is table, set the required options for the joined index tablespace:

Menu Entry	Meaning
Index tablespace file name (xfile)	-f tscreate -xf\|-xfile
Raw disk / link target (xrawlink)	-f tscreate -xr\|-xrawlink
File size in MB (xsize)	-f tscreate -xs\|-xsize
File autoextend mode (xautoextend)	-f tscreate -xa\|-xautoextend
Maximum file size in MB (xmaxsize)	-f tscreate -xm\|-xmaxsize
File increment size in MB (xincrsize)	-f tscreate -xi\|-xincrsize
SQL command (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

If required, repeat the previous step when prompted by BRSPACE with message BR1091I.

You can add up to five files to the selected tablespace by repeating the previous

Note
For the xfile option, you can enter not only full path names, but also the sapdata path name, sapdata<N>, or just <N> to specify in which sapdata directory the file is to be located. BRSPACE automatically extends the incomplete file name to the full path name according to the SAP naming conventions.
To start processing with the selected options, choose Continue.

Note
BRSPACE creates the table tablespace in step 6 and index tablespaces in this step.

Results

Check the results in the BRSPACE logs.

The summary log space<DBSID>.log displays the return code.
The detail log s<encoded timestamp>.tsc displays the details.
The structure change log struc<DBSID>.log logs all structure changes.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.