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: Ketaxe Tojazilkree
Country: Cambodia
Language: English (Spanish)
Genre: Medical
Published (Last): 10 April 2006
Pages: 387
PDF File Size: 16.20 Mb
ePub File Size: 2.39 Mb
ISBN: 493-9-80613-249-5
Downloads: 56400
Price: Free* [*Free Regsitration Required]
Uploader: Najind

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

SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy

This brtoole the command to change password of Oracle Database User: Choose the category and then the class that you require. If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database.

If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: Unless you know the object name, we recommend you to use main menu mode.

In SAP Netweaver 7.


The alternative to quick mode is main menu modein which you only use the menus in BRSPACE to enter the options required to perform a function. Be very careful vrtools —c force because it forces default selection of all unspecified options, which might lead to unexpected results. Show database space information.

Show database object information. With these functions you should also enter an action to specify what kind of alter function you require.

The field for the object name is filled with your entry. This site uses cookies. You can now enter all required options and execute the function immediately.

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

You use quick mode from: This is un important question before we plan to brtooos table in SAP system. By continuing to use this website, you agree to their use. You can perform the following types of reorganization: Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself.

Show database instance information Show database space information Show database object information Choose the category and then the class that you require.

Here is the example using brspace: All other confirmation prompts and so on are skipped. Unix system, with Oracle database. Solution Run this command using root user to update authorization needed for running brtools: For more information, see: The following graphic illustrates in outline how quick mode works: Enter table name in Table names table. Choose Segement Management or run from the command prompt brspace —f tbreorg.


Choose continue to start processing. Exceptions to quick mode There are the following exceptions to quick mode: This will make you unable to run some commands from SAP.

BRtools and DB02 information:

They jump directly to the final input menu to let you enter the remaining required parameters and execute the function immediately. This may be due to different character set, ssap copying text from Ms Word to command prompt. 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.