Show TOC

Extending a Tablespace with BR*ToolsLocate this document in the navigation structure

Context

You can use BR*Tools for Oracle to extend a tablespace by adding a data file.

Note

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

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

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  Next navigation step Extend tablespace End of the navigation path

        BRGUI or BRTOOLS displays the menu BRSPACE options for tablespace extension, 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

        Tablespace name (tablespace)

        -f tsextend -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 tsextend command that is to be executed using the current settings.

      3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

      4. Choose Continue to start BRSPACE.

    • Command line

      You need to enter at least the following command:

      brspace -f tsextend

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

      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.

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

    BRSPACE displays the Tablespace extension main menu.

  3. Choose Extend tablespace.

    BRSPACE displays the list of tablespaces:

    List Entry

    Meaning

    Pos

    List sequence number

    Tablespace

    Tablespace name

    Files/AuExt

    Number of data files / number of data files with autoextend

    Total [KB]

    Total size of all data files of the tablespace

    Used[%]

    Percentage of space in tablespace that is used

    Free [KB]

    Amount of space in tablespace that is free

    MaxSize [KB]

    Maximum size that the tablespace can be autoextended

  4. Select a tablespace.

    BRSPACE displays the menu Options for extension of tablespace.

  5. Set the required options:

    Menu Entry

    Meaning

    Last added file name (lastfile)

    - display only

    The name of the last file that was added to the tablespace

    Last added file size in MB (lastsize)

    - display only

    The size of the last file that was added to the tablespace

    New file to be added (file)

    -f tsextend -f|-file

    Raw disk / link target (rawlink)

    -f tsextend -r|-rawlink

    Size of the new file in MB (size)

    -f tsextend -s|-size

    File autoextend mode (autoextend)

    -f tsextend -a|-autoextend

    Maximum file size in MB (maxsize)

    -f tsextend -m|-maxsize

    File increment size in MB (incrsize)

    -f tsextend -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.

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

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

Results

Check the results in the BRSPACE logs.

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