Make sure you have set the necessary BRCONNECT parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRCONNECT.
The database must be open.
It only makes sense to adapt next extents for tablespaces that are dictionary-managed. If all tablespaces are locally managed, do not use this function.
You can adapt the next extents for tables in your Oracle database with BR*Tools. The aim is to avoid extent overflow, which causes transactions to abort.
For more information, see:
Start BRGUI or BRTOOLS.
Choose
.Set the required options:
Menu Entry |
Equivalent BRCONNECT Command Option |
---|---|
BRCONNECT profile (profile) |
|
Database user/password (user) |
|
Database owner for adapt (owner) |
|
Maximum extent size in KB (max) |
|
Maximum extent count (limit) |
|
Special NEXT extents (special) |
|
Exclude from adapt (exclude) |
|
Tables for adapt (table) |
|
Confirmation mode (confirm) |
|
Query mode (query) |
|
Force options (force) |
|
Additional output (output) |
|
Message language (language) |
|
BRCONNECT command line (command) |
This shows you the BRCONNECT -f next command that is to be executed using the current settings. |
To start processing with the selected options, choose Continue.
Check the results in the BRCONNECT logs.
The summary log conn<DBSID>.log displays the return code.
The detail log c<encoded timestamp>.nxt displays the progress.
For more information about how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.