Show TOC

Procedure documentationShowing Database Owners with BR*Tools Locate this document in the navigation structure

 

You can use BR*Tools for Oracle to show information about database owners.

Procedure

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

    • BRGUI or BRTOOLS:

      1. Choose   Instance Management   Show database owners  .

        BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, 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

        Database owner (owner)

        -f dbshow -o|-owner

        Create log file (log)

        -f dbshow -l|-log

        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 dbshow -c dbowner 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:

      Enter at least the following command:

      brspace -f dbshow -c dbowner

      You can enter more parameters if required. For more information, see BRSPACE -f dbowner.

    BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log if you set the option Create log file (parameter -l|-log).

    Note Note

    If you started BRSPACE from the command line without the information class name (-c|-class) – that is, with brspace -f dbshow – BRSPACE displays the Show database information main menu.

    Choose   Show database instance information   Show database owners  .

    End of the note.
  2. If you have already entered the owner name, continue with step 4.

    BRSPACE displays the List of database owners:

    List Entry

    Meaning

    Pos.

    List sequence number

    Owner

    Owner name

    Id.

    Owner ID

    Created

    Date that the owner was created

    Deft-Tsp.

    Default tablespace for owner

    Temp-Tsp.

    Temporary tablespace for owner

    Status

    Status of owner

  3. To see more information, select one or more database owners.

    Example Example

    These examples apply only to input in character mode.

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

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

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

    To select all entries, enter 0.

    End of the example.

    BRSPACE displays Information about database parameter:

    List Entry

    Meaning

    Owner Id (owner_id)

    Database owner ID

    Created date (created)

    Date that the owner was created

    Default tablespace (deft_tsp)

    Default tablespace for owner

    Temporary tablespace (temp_tsp)

    Temporary tablespace for owner

    Owner status (status)

    Status of owner

  4. If you specified multiple owners, choose Continue to scroll through.

Result

If you set the option Create log file (parameter -l|-log), check the results in the BRSPACE logs.

  • The summary log space<DBSID>.log displays the return code.

  • The detail log s<encoded timestamp>.dbw displays the details.

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