You can use BR*Tools for Oracle to show information about database owners.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS:
Choose
.BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.
Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
---|---|
BRSPACE profile (profile) |
|
Database user/password (user) |
|
Database owner (owner) |
|
Create log file (log) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshow -c dbowner 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:
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
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
.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 |
To see more information, select one or more database owners.
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.
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 |
If you specified multiple owners, choose Continue to scroll through.
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.