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: Shakalkree Fenrile
Country: Canada
Language: English (Spanish)
Genre: Education
Published (Last): 26 February 2006
Pages: 210
PDF File Size: 19.65 Mb
ePub File Size: 1.77 Mb
ISBN: 491-8-52354-533-1
Downloads: 33848
Price: Free* [*Free Regsitration Required]
Uploader: Meztilkree

The more you set the thread, the faster your process will be. This site uses cookies.

Unless you know the object name, we recommend you to use main menu mode. You enter the command options required directly from the command line: They jump directly to the final input menu to let you enter the remaining required parameters and execute the function immediately.

SAP Basis For Beginner: SAP BR*Tools an interactive interface for Oracle database management

To find out more, including how to control cookies, see here: There are the following exceptions to quick mode: Show database space information. You can perform the following types of reorganization: Otherwise, the appropriate menus are shown for the function you select. 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.


BRSPACE starts by displaying the function main menu for the function that you entered, which is Alter database parameter in this example.

For quick mode, you must specify at least the function and the object name.

Bryools the category and then the class that you require. This is the command to change password of Oracle Database User: By continuing to use this website, you agree to their use. Solution Run this command using root user to update authorization needed for running brtools: The alternative to swp mode is main menu modein which you only use the menus in BRSPACE to enter the options required to perform a function.

SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy

There are the following reasons for this: Choose Segement Management or run from the command prompt brspace —f tbreorg. This will make you unable to run some commands from SAP. Why do we need to reorganize table in SAP system?

This is the important question before we plan to reorganize table in SAP system. The following graphic illustrates in outline how quick mode works: You use brgools mode from: Enter table name in Table names table. If the list is not what you require, you can go back and make a new selection.

  DIN 50602 PDF

If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization.

Recent Posts

This may be due to different character set, like copying text from Ms Word to command prompt. Show database instance information. Unix system, with Oracle szp.

Run this command using bdtools user to update authorization needed for running brtools: Software Configuration o Standby Database o init.

Here is the example using brspace:.