Increasing Table Space

[Former Member]

I'm new to SAP, so please do tell me how to increase the table space..

Thanks in Advance,

Indu.

[Former Member · Accepted solution]

Just use the Command <sapdba> at ur command prompt and follow the instruction to administer the TableSpaces

Abhishek

[Former Member · Accepted solution]

Login as ORA<SID>

SAPDBA

select option C--Table space administration

give table space name to which space will add

give path of the datafile

size of the data file

start

[Former Member · Accepted solution]

HI Indu

You hav'nt mentioned whats ur database is it oracle or db2 ?

for oracle as mentioned earlier: you can use brtools to add datafile

for DB2 you have to add containers

ALTER TABLESPACE <name>

ADD (DEVICE '<path>' <size>, FILE '<filename>' <size>)

regards

dEE

[Former Member]

Thanks alot i got very useful answers. So im closing this thread.

Thanks & Reagards,

Indu

[Former Member]

Hi Indu,

If you are using oracle...Issue the following command at SQL prompt

Alter tablespace <TABLE SPACE NAME> add datafile '<LOcation of new datafile to be added>' size XXXXM Auto extend [Off/ON];

You can use BRtools to extend the table space..navigation is as shown below:

brtools:

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Enter choice:2

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset program status

Enter choice:1

1 - BRSPACE profile (profile) ...... [initSID.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initSID.sap -s 20 -l E -f tsextend]

Enter choice:3

Give table space name:

BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initSID.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [TSNAME]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initSID.sap -s 20 -l E -f tsextend -t TSNAME]

Type continue(C)

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata3/sr3_10/sr3.data10]

2 * Last added file size in MB (lastsize) . [2000]

3 - New file to be added (file) ........... [/oracle/SID/sapdata3/sr3_11/sr3.data11]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [2000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

Give the file path where u want to create datafile and give the required size..

Type continue..

TS will extend..

Check log in /oracle/SID/sapbackup..

Hope this helps....

Regards,

Phani

[Former Member]

BRTOOLS can be used to increase the tablespace. Step by step procedure is here:

http://help.sap.com/saphelp_erp2004/helpdata/EN/fb/90a584038a8f45b116d5d90ce9c23b/frameset.htm

[Former Member]

HI

The tablespaces are increased by adding datafiles to the tablespaces.This is done by using BRTOOLS.

Please refer to the following links for more:

http://sapbasis.wordpress.com/2008/06/20/create-new-tablespace-on-sap-r3-server-using-brtools/

or

http://www.sap-img.com/basis/how-to-increase-the-tablespace-free-space.htm

I hope this would help you.

Regards

Chen