Interactively from the BRGUI graphical interface or the BRTOOLS character interface. · Directly from the command line using the relevant BR*Tools options. SAP Database Administration Using BRTOOLS SAP provides a number of tools to administer the underlying Oracle Database. The combined group of tools is. 1) SAP delivers the “BR*Tools” to provide an interactive Oracle database administration tools 3) Different between BR*Tools and BRTOOLS.

Author: Akizahn Zolokora
Country: Venezuela
Language: English (Spanish)
Genre: Health and Food
Published (Last): 11 March 2007
Pages: 476
PDF File Size: 9.55 Mb
ePub File Size: 14.38 Mb
ISBN: 229-8-66422-162-9
Downloads: 41206
Price: Free* [*Free Regsitration Required]
Uploader: Brataur

Unless you know the object name, we recommend you to use main menu mode.

This site uses cookies. Reorganizing table can also be used to improve database structure, transform dictionary managed to locally managed tablespace, merge data in tablespace from many small files into larger files and perform segments defragmentation. You use quick mode from: Enter table name in Table names table.

The alternative to quick mode is main menu modein which you only brtoolz the menus in BRSPACE to enter the options required to perform a function. This will make you unable to run some commands from SAP.

There are the following reasons for this: BRW Error message from likeywlib: This is the important question before we plan to reorganize table in SAP system. If the command options are correct and complete, the SAP tool is executed immediately to bbrtools a function on the database.


Exceptions to quick brtoola There are the following exceptions to quick mode: You can now enter all required options and execute the function immediately. You can perform the following types of reorganization: Software Configuration o Standby Database o init.

Recent Posts

The field for the object name is filled with your entry. The following graphic illustrates rbtools outline how quick mode works: Otherwise, the appropriate menus are shown for the function you select. Show database instance information.

Unix system, with Oracle database. Choose the category and then the class that you require.

BRTOOLS (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))

In this case, you have to type the command manually. Run this command using root user to update authorization needed for running brtools: Show database instance information Show database space information Show database object information Choose the category and then the class that you require. However, you might get errors if you change the command. If you do not specify a function, the tool is called with the default function when you start it from the command line: If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: For more information, see: Here is the example using brspace: You can also enter additional options in quick mode.


Choose Segement Management or run from the command prompt brspace —f tbreorg.

BRtools and DB02 information:

Show database object information. With these functions you should also enter an action to specify what kind of brools function you require. Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results.

Show database space information. One of grtools strategy is to reorg certain table which can impact on system performance. Solution Run this command using root user to update authorization needed for running brtools: The exception to this is for the functions in segment management, where it makes no sense to display all tables or indexes, because the list would be too long.

If the list is not what you require, you can go back and make a new selection.