cancel
Showing results for 
Search instead for 
Did you mean: 

Tablespace 0% free - Oracle / NT

LeonardoAraujo
Active Contributor
0 Kudos

My client copies are failing due to lack of tablespace room.

IN DB02 I have the following info:

Total number 6

Total size/kb 152.750.080

Total free/kb 2.607.104 1 %

Minimum free/kb 16.384

Max. autoextensible/kb 563,200,000

ON Freespace statistics I have:

Tablespace Freespace

Maximum/kb Maximum/kb Total/kb

SYSTEM 260032 260928

PSAPUNDO 0 0

PSAPTEMP 0 0

PSAPIDS 19392 20544

PSAPIDS640 12224 97408

PSAPIDSUSR 16384 16384

ON Critical Tables/IND...

Tablespace Freespace /kb Next extent/k

Maximum Total

PSAPUNDO 0 0 8.192

PSAPUNDO 0 0 65.536

PSAPUNDO 0 0 8.192

PSAPUNDO 0 0 8.192

PSAPUNDO 0 0 65.536

PSAPUNDO 0 0 65.536

PSAPUNDO 0 0 8.192

PSAPUNDO 0 0 8.192

PSAPUNDO 0 0 65.536

PSAPUNDO 0 0 8.192

I've tried to run DBA planning calendar the actions below:

NEXT Extent. The following command was issued:

BRCONNECT -u / -c -f next -t ALL,PSAPIDS,PSAPIDS640,PSAPIDSUSR,PSAPTEMP,PSAPUNDO

REsult:

BR0903I Number of tables in locally managed tablespaces: 47323

BR0904I Number of indexes in locally managed tablespaces: 57328

BR0901I Number of tables to check (and adapt if needed) next extent: 0

BR0902I Number of indexes to check (and adapt if needed) next extent: 0

BR0905W No tables/indexes found to check and adapt next extent

If I try on CMD BRCONNECT -f NEXT I get the error

ORA-01017: Invalid user/password; logon denied.

How Can I extend the tablespaces? I need to finish my client copy.

Thanks a lot.

Message was edited by: Leonardo De Araujo

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Leonardo,

It's a while since I've worked on an Oracle based SAP system but this is what I remember.

Do you know exactly which tablespace(s) are filling during the client copy ? You can probably see them on the SAP system log. I guess it will be one of BTABD/I, STABD/I, POOLD/I or CLUD/I.

Once you've identified the tablespace(s) that have filled, you can add datafiles to the affected tablespace(s) using sapdba.

The following SAP Help Portal URL may also be of use:

http://help.sap.com/saphelp_47x200/helpdata/en/42/51b3144a1211d182b80000e829fbfe/frameset.htm

Regards,

Gary

LeonardoAraujo
Active Contributor
0 Kudos

I was able to solve my problem.

The tablespaces that were completely full were the TEMP and the UNDO (new ROLL).

I've extended those and continued.

Thanks for the info.

Answers (0)