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.
|Published (Last):||22 February 2009|
|PDF File Size:||12.3 Mb|
|ePub File Size:||1.88 Mb|
|Price:||Free* [*Free Regsitration Required]|
The ij for the object name is filled with your entry. For quick mode, you must specify at least the function and the object name.
With these functions you should also enter an action to specify what kind of alter function you require. When you have finished executing a function and you choose back after starting BRSPACE in quick mode, the quick mode is deactivated and you can choose a new object to execute the function again.
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. Choose Segement Management or run from the command prompt brspace —f tbreorg. Enter table name in Table names table. You use quick mode from: You can now enter all required brrools and execute the function immediately. This is the command to change password of Oracle Database User: Show database object information.
Why do we need to reorganize table in SAP system?
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
In this case, you have to type the command manually. 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. In SAP Netweaver 7. Please take note that this online reorganization will impact on system ssap, therefore you need to run this when the system load is low.
BRTOOLS | MY SAP BASIS
Here is the example using brspace: BRW Error message from likeywlib: For example in DB13, you will have an error when you schedule job like check database and update optimizer. Unless you know the object name, we recommend you to use main menu mode. If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database.
Improvements to handling of database statistics. Show database instance information.
There are the following reasons for this: If the list is not what you require, you can go back and make a new selection. 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.
BRtools and DB02 information:
There are the following exceptions to quick mode: This is the important question before we plan to reorganize table in SAP system. Here is the example using brspace:.
All other confirmation prompts and so on are skipped.