Adapting Next Extents with BR*Tools


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 Adapt Next Extents with BRCONNECT.


·        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.



       1.      Start BRGUI or BRTOOLS.

       2.      Choose Additional functions ® Adapt next extents.

       3.      Set the required options:

Menu Entry

Equivalent BRCONNECT

Command Option

BRCONNECT profile (profile)


Database user/password (user)


Database owner for adapt (owner)

-f next -o|-owner

Maximum extent size in KB (max)

-f next -m|-max

Maximum extent count (limit)

-f next -l|-limit

Special NEXT extents (special)

-f next -s|-special

Exclude from adapt (exclude)

-f next -e|-exclude

Tables for adapt (table)

-f next -t|-table

Confirmation mode (confirm)


Query mode (query)


Force options (force)

-f next -f|-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.

       4.      To start processing with the selected options, choose Continue.

       5.      Check the results in the BRCONNECT logs.

Ў        The summary log conn<DBSID>.logdisplays the return code.

Ў        The detail log  c<encoded timestamp>.nxt displays the progress.

For more information on how to view the logs with BR*Tools, see Showing Logs with BR*Tools.