Tablespace is full

[Former Member]

Dear Expert,

In my Quality server one Tablespace name PSAPSR3 is 99% full. Previously it wat Autoextend on but now its autoextend off.

so right now only 25 MB space is free.

So should i have to add 1 more data file? or extend the size of table space? what happen if size is not increase?

waiting for your reply.

Regards

Nisit Patel

[debasissahoo · Accepted solution]

Hi Nisit,

Giving an sql might be the easiest way to do. But always recommended to use brtool for SAP.

If you go by brtools, then Choose,

Brtools > Space management > Extend tablespace > add datafile.

(if you're adding datafile for the first time in brtools, please note that after you give first set of data brtool will ask you whether you want to continue with another one... if you press continue there it will again ask for the 2nd datafile you want to add. SO if you want to add only 1 datafile, when it asks for another datafile add.. you should use NO)

more help..

http://help.sap.com/saphelp_nw70/helpdata/EN/a7/8db6c2ebc5384eb82e5f99e49600d6/frameset.htm

Regards,

Debasis.

[Former Member · Accepted solution]

Dear Debasis

Thanks for your prompt reply.

Regards,

Nisit

[debasissahoo · Accepted solution]

you are welcome..

[former_member204746 · Accepted solution]

I would not add a datafile, I would extend an existing one. you can do this with:

brspace -c -u / -f dfalter

to add datafile:

brspace -c -u / -f tsextend

[Former Member · Accepted solution]

Hi,

Can we add datafile in Tablespace online?OR we need to stopsap & database, then add datafile?

Regards,

Nisit

[debasissahoo · Accepted solution]

Hi Nisit,

For adding the datafile, you can do it online of both SAP and Oracle.

The onlything is, if there are activities going on in the system, while adding the datafile through brtools, it will take some time as it internally does some checks before adding the datafile.

but it can be done online.

hope this will clarify your question.

Regards,

Debasis.

[Former Member]

Hi

First check if there is space available at OS level. If it is so you can proceed with extending datafile using brtools.But usually in oracle we keep the limit of datafile t 10 GB.Hope it will help you,

[Former Member]

Online.

[Former Member]

Hi Nishit ,

There is two options to create space in tablespace

1. reorgenize the table space by reorgenizing

2. add more data files through tableexetend

login through <sid>adm user

brspace -f tsextend

[Former Member]

Hi Neeraj,

Thanks for the reply.

can i use brtools commad to add datafile?

Regards,

Nisit

[debasissahoo]

Nisit,

Yes, you can use brtools to add the data file.

before that, just make sure that you've space fee in the OS level where you will be creating the new datafile.

Regards,

Debasis.

[Former Member]

Hi Nishit,

you can also use sql command to extend the tablespace by adding data file. the command will be

" alter tablespace PSAPSR3 add datafile '/oracle/SR3/sapdata4/sr3_12/sr3.data12' size 2000M autoextend on next 20M maxsize M "

it depends on you which process you choose .

I think brspace -f tsextend is the easiest way to extend the tablespace