Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table reorganisation on oracle DB using shell script

HI Experts

We are on Oracle 11g and solaris sun4v(OS).We have set of tables that are reorganised every week.

To avoid manual work in this process I thougt of using brspace command:brspace -u / -f tbreorg from shell script.

But even this command asks for the conformation before starting reorganisation.

Can anyone advise on how this could be automated without any manual intervention.





Check these links


This BRSPACE command option specifies whether processing is attended or unattended. In unattended mode, BRSPACE only stops at menus and yes/no queries. At other prompts, it continues processing with the default value.

Syntax Syntax

  1. -c|-confirm [force]

Default value: attended mode. You need to respond to the prompts and menus generated by BRSPACE. You also have to check the default choices and input values suggested by BRSPACE.

Possible value:

force: suppresses all confirmation messages and automatically selects default choices and accepts default input values in menus

Caution Caution

Do not use the option -c force unless you are sure of the outcome because it might produce unexpected results.

Eg: brspace -c force -u / -f tbreorg -t TABLE_NAME



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question