Problem solve Get help with specific problems with your technologies, process and projects.

Online reorganization with BR

Have you ever wanted to reorganize tables online while running SAP? This tip will teach you how, using Oracle 9.2 and SAP's BR*Tools 6.40.

As of Oracle 9.2 it is possible to reorganize tables online (while SAP is running) using SAP's BR*Tools 6.40. This...

can be used with all SAP releases as long as the Oracle release is 9.2. You can download the BR*Tools (DBATL640O92….SAR) as a SAR file from the SAP Service Marketplace.

After extracting the SAR file into the run directory you may need to execute the included "sapdba_role.sql" script to update the sapdba role. The new 6.40 tools may also require additional Microsoft runtime DLLs. If so download and run R3DLLINS.EXE attached to note 684106.

After correctly installing BR*Tools, type "brtools" at the command line to get started. See note 646681 for further details.

Online table reorganization creates a lot of redo log info -- therefore it is necessary to plan for this in advance so that the file system has adequate space. One option is to increase the frequency of redo log backups. Because of the way the online reorganization works -- it creates a copy of the table(s) inside the database -- it is also necessary to have adequate space in the database.

This was last published in February 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close