extending table spaces

[Former Member]

Hi all,

I need to extend the table spaces for PSAPBTABD N PASAPBTABI as they are 90% filled.Can any body tell me how to extend table space from database level.Please tell me the commands.

Thanks in advance for the help,

chandu

[Former Member]

using brtools

[Former Member]

hi

you will have to use BRTOOLS said

check out this link

http://sapbasis.wordpress.com/tag/tablespace/

it contains the procedure of doing that with screenshots

Rohit

[Former Member]

Hi Rohit,

do i need to have any rights to use this br tools.Please let me know from where i can use these br tools and which one.

Thanks in advance,

chandu

[Former Member]

hi

you have to log on OS level of the system and as user ora<SID>

open the command line and type BRTOOLS

then follow the steps that I have given you in the previous post

Rohit

[Former Member]

Chandra try this

1.Login to SAP server using <sid>adm (windows) or ora<sid> (Unix)

2.Execute u2018brtoolsu2019 from command prompt

3.Select option u20182u2019 to Increase the table space size

4.selection option u20185u2019 to resize the data file

5.select option 3 and write u2018resizeu2019 in the input box to resize the data file

6.select option 4 to select the table space name

7.select option u20185u2019 to provide the data file name or data file id

8.press u2018cu2019 to continue

9.Press u2018cu2019 again to proceed

10.select option u20187u2019 to provide the new data file size

New data file size is the original size + new size

11. press u2018cu2019 to continue

11.press u2018cu2019 to continue

12.press u2018bu2019 to back

13.press u20189u2019 to exit.

14.login to SAP and execute DB02 -> Refresh and check the new table space size

[Former Member]

Hello Chandrashekar,

Two options are available at BRTOOLS. You can resize the existing datafiles or you can add a new datafile. Which one you like to go

Tnx -- Jo

[Former Member]

Hi

Use brtools

select option 2: Space Management

select option 1: Extend Tablespace

select option 3:Give your tablespace name which you want to extend

C and C twice

select option 3 :Which datafile you need to addfrom

select option 5: size of the datafile to be added

Regards

Uday

[JPReyes]

just extend them using BRTOOLS

http://help.sap.com/saphelp_nw04/helpdata/EN/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

Regards

Juan