Table reorganisation on oracle DB using shell script

[former_member228202]

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.

Regards

VC

[Reagan · Accepted solution]

Hello

Check these links

http://help.sap.com/saphelp_nw70/helpdata/en/cb/376c1d44ec274daa70e5e07cfa09c6/content.htm

http://help.sap.com/saphelp_nw73/helpdata/en/46/badd1ecdf21516e10000000a114a6b/content.htm

-c|-confirm
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
-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
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

Regards

RB

[former_member228202 · Accepted solution]

HI RB

I could automate the entire process using the above command.

Thanks a lot for the reply.

Regards

VC