Altering a Tablespace with BR*Tools 

Use

You can use BR*Tools  for Oracle to alter a tablespace as follows:

·        Set tablespace online

·        Set tablespace offline

·        Set backup status

·        Reset backup status

·        Coalesce free extents

·        Rename tablespace (Oracle 10g or higher)

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

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

Procedure

...

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

¡        BRGUI or BRTOOLS:

                                                  i.       Choose Space Management → Alter tablespace.

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

                                                ii.       Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p|-profile
Database user/password (user)	-u|-user
Alter tablespace action (action)	-f tsalter -a|-action
Tablespace names (tablespace)	-f tsalter -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 tsalter command that is to be executed using the current settings.

If required, in Tablespace names you can enter the names of multiple tablespaces, but you cannot use wildcards. But this entry and alter action entry are optional.

For example, PSAPRAWI,PSAPRAWD is a valid entry, but PSAPRAW* is not a valid entry.

                                               iii.       Choose Continue.

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                               iv.       Choose Continue to start BRSPACE.

¡        Command line:

...

Enter at least the following command:

brspace –f tsalter

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

Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can use 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.

BRSPACE displays the Alter tablespace main menu.

       2.      If you have already entered the tablespace name and action, continue with step 6 (quick mode).

If you have entered multiple tablespaces, BRSPACE displays as confirmation a List of tablespaces for alter. You cannot make a selection from this list. If required, go back and make a new selection.

Continue with step 6 (quick mode).

       3.      Choose or confirm the required action:

¡        Set tablespace online

¡        Set tablespace offline

¡        Set backup status

¡        Reset backup status

¡        Coalesce free extents

¡        Rename tablespace

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

BRSPACE displays the tablespace list:

List Entry	Meaning
Pos.	List sequence number
Tablespace	Tablespace name
Files/AuExt.	Number of data files / number of data files with autoextend set
Type	Tablespace type: data, temp or undo
Status	Tablespace status – online or offline
SegMan.	Segment space management – auto or manual
ExtMan.	Tablespace extent management – local or dictionary
Backup	Tablespace backup status

BRSPACE only displays the tablespaces that can be processed by your chosen action.

For example, if you choose Set tablespace online, only the tablespaces that are currently offline are displayed.

       5.      Select a tablespace or multiple tablespaces.

These examples apply only to input in character mode.

To select the first three tablespaces in the list, enter 1-3.

To select the first and third tablespaces, enter 1,3.

To select the first three tablespaces and the fifth, enter 1-3,5.

To select all entries, enter 0.

BRSPACE displays the menu, Options for alter of tablespace.

       6.      Set the required options:

Menu Entry	Meaning
Current tablespace status (status) – display only	Current status of the tablespace
Current backup status (backup) – display only	Current backup status of the tablespace
Alter tablespace action (action) – display only	The action that you selected above
Set offline mode (mode)	-f tsalter -m|-mode
New tablespace name (name)	-f tsalter -n|-name
Force alter tablespace (force)	-f tsalter -f|-force
SQLPLUS command line (command)	The SQL command that is to be executed using the current settings. For more information, see your Oracle SQL documentation.

       7.      To start processing with the selected options, choose Continue.

Results

Check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays the return code.

·        The detail log s<encoded timestamp>.tsa displays the details.

·        The structure change log struc<DBSID>.log records all structure changes (rename tablepsace)

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