Table shows 100% in DB02 (Prod)

[Former Member]

Dear all,

In production one of the Table space shows 100% .

Pls check below DB02 details :

Table space name "PSAPSR3

Size (MB)=199,080.00

free (MB)84.19

used % =100%

Auto extend =YES

Total Space(MB)=200,000.00

Sum of all free fregments (MB)=1,004.19

Total USed % =99

Files =20

Segments=157,305

226,157

ONLINE

PERMANENT

Kindl

[former_member204746]

I am locking this.

basic training would cover this.

go get training.

[former_member199632]

Hi,

yes, you have to extend the existing Tablespace (PSAPSR3)

OR

you can add one more datafile and add that to the PSAPSR3 tablespace

refresh DB02

regards

[former_member227283]

Hi,

Extend the table space using brtools.

Thanks

Anil