Procedure documentationAltering a Tablespace with BR*Tools

 

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)

    Note Note

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

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

    End of the note.

Procedure

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

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Space Management Alter tablespace. End of the navigation path

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

      2. 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.

        Note Note

        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.

        End of the note.

      3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

      4. 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.

      Note Note

      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.

      End of the note.

    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. You can use quick mode as follows:

    • If you have already entered the action, continue with step 4.

    • If you have already entered the tablespace name and action, continue with step 6.

    Note Note

    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).

    End of the note.

  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

    Note Note

    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.

    End of the note.

  5. Select a tablespace or multiple tablespaces.

    Example Example

    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.

    End of the example.

  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.

Result

Check the results in the BRSPACE logsBRSPACE Logs.

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