8/14/2019 76927089-BRTOOLS

1/12

How to Add an Oracle datafile using BRTOOLS

1. Logon to the systems as ora2. Execute brtools

3. Select 2 Space management!. Select 1 Extend tablespace". Select 3 tablespace name #. Select $ $ontinue%. Select 3 &e' (ile to be added )(ile path* )+ptional*,. Select " Si-e o( the ne' (ile in / )+ptional*0. Select # uto extend ) es &o* )+ptional*14. Select % aximal (ile si-e in / ) axsi-e* )+ptional*11. ou can see the s5l statement in option 0 S6L command. )+ptional*12. 7o continue select $ Execute the s5l command.13. Select continue and con(irm the return to /87++LS menu.

1!. Exit (rom the Space management menu using b )bac9*1". &o' it is possible to exit (rom /87++LS using option 0 Exit program .

NOTE: Check next page for a detailed procedure

8/14/2019 76927089-BRTOOLS

2/12

8/14/2019 76927089-BRTOOLS

3/12

8/14/2019 76927089-BRTOOLS

4/12

8/14/2019 76927089-BRTOOLS

5/12

8/14/2019 76927089-BRTOOLS

6/12

8/14/2019 76927089-BRTOOLS

7/12

How to extend an Oracle datafile using BRTOOLS

Summary

1. Logon to the systems as ora2. Execute brtools3. Select 2 Space management!. Select ! lter data (ile". Select 3 lter data (ile action )action* and type resize #. Select ! 7ablespace name )tablespace* and type the tablespace name%. Select " :ata (ile names )(ile* and speci(y the complete path o( the data (ile,. $hec9 the input data and select continue to launch the /8S; $E inter(ace.0. $on(irm the call to /8S; $E14. Select % &e' data (ile si-e in / )incrsi-e* and speci(y the ne' si-e in /11. $hec9 the input data and select continue )this 'ill actually execute the resi-ing*.

Loo9 (or any error messages.12. Select continue and con(irm the return to /87++LS menu.13. Exit (rom the Space management menu using b )bac9*1!. &o' it is possible to exit (rom /87++LS using option 0 Exit program .

NOTE: Check next page for a detailed procedure

8/14/2019 76927089-BRTOOLS

8/12

Detailed procedure

1. Logon to the systems as ora2. Execute brtools

3. Select 2 Space management

8/14/2019 76927089-BRTOOLS

9/12

!. Select ! lter data (ile=t is obligatory to (ill items mar9ed 'ith .

". Select 3 lter data (ile action )action* and type resize

#. Select ! 7ablespace name )tablespace* and type the tablespace name

8/14/2019 76927089-BRTOOLS

10/12

%. Select " :ata (ile names )(ile* and speci(y the complete path o( the data (ile

,. $hec9 the input data and select c to continue to launch the /8S; $E inter(ace.

:ata(iles can be chec9ed 'ithin the S ; system 'ith transaction :/42 ?> $urrent si-es?> Select the tablespace ?> :ata (iles 7emp (iles

8/14/2019 76927089-BRTOOLS

11/12

0. $on(irm the call to /8S; $E

14. Select % &e' data (ile si-e in / )incrsi-e* and speci(y the ne' si-e in /

8/14/2019 76927089-BRTOOLS

12/12

11. $hec9 the input data and select continue )this 'ill actually execute the resi-ing*.Loo9 (or any error messages.

12. Select continue and con(irm the return to /87++LS.13. Exit (rom the Space management menu using b )bac9*1!. &o' it is possible to exit (rom /87++LS using option 0 Exit program .