on 08-02-2013 2:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.