Register Login

Extending Tablespace using BRTOOLS

Updated May 18, 2018

Hi,
Please find the .

1.Analyze what tablespace should be extent, please check the available space
carefully before decide to extent table space
2.Go to server login with adm
3.Run brtools
4.Go to space management (option number 2)
5.Go to extend tablespace (option number 1)
6.Check the option, if it’s ok wih the default setting type c then enter to continue to next brspace process
7.Go to extend tablespace (option number 1)
8.All tablespaces will be appeared enter to scroll down choose the tablespace which will be extended
9.Mandatory option to be checked is option number 3 (New file to be added (file))
use to locate where new datafile will be created
10.Also check option number 5 (Size of the new file in MB (size) make sure destination is enough to create new datafile
11.Continue
12.When system ask to add next data file automatically please don’t choose yes
chose no / continue to continuing the process on normal condition next datafiles should be defined one by one
13.Don’t forget to choose exit after finish

Regards,
 


Comments

  • 02 Feb 2011 11:09 am rekha
    The above steps is similar as what we do in SAPDBA.
  • 02 Feb 2011 11:09 am rekha
    Yes there is no much difference between SAPDBA and BRTOOLS. as i said earlier its the version changes and in the same way BRTOOLS been added instead of SAPDBA. in one word i can say its an updated version to SAPDBA.
  • 27 Oct 2013 7:08 am Guest
    what will happen if we select yes instead of continue on step number 12 after increasing the table space ?

×