Skip to Content

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.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 02, 2013 at 10:43 PM


    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



    Add comment
    10|10000 characters needed characters exceeded