Table reorganisation on oracle DB using shell script
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.
Reagan Benjamin replied
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.
- -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.
force: suppresses all confirmation messages and automatically selects default choices and accepts default input values in menus
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