HOW TO EXTEND TABLE SPACE SAPTEMP with brtools

[Former Member]

Hi All,

I need to extend table space , i want to know how to extend table space using brtools

Thanks in advance

Shams

[former_member603052 · Accepted solution]

Hi,

Execute Brtools from the command prompt.

Select 2 (space management)--> 1 (extend Tablespace) -->3 and the give the tablespace name you want to extend and follow the instructions.

Kalyan

[Former Member · Accepted solution]

Hi Kalyan,

Thanks kalyan its working.

Regards

Shams

[former_member204746 · Accepted solution]

instead of creating a new datafile, you could have resized an existing datafile:

brspace -c -u / -f dfalter

option 5

[Former Member]

Hi Shams,

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.

Hoping this info is valuable.

Thanks.

Best Regards,

Smiley Ohri