cancel
Showing results for 
Search instead for 
Did you mean: 

FREE SPACE COLLECTION AFTER CLIENT DELETION

Former Member
0 Kudos

Hi,

I delete a client but there is no effect on the database size.... means all the table space are having the same size as before client deletion...

What to do... to recollect all the free space after client deletion...???

Regards,

Neehir Bhatt

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Neehir,

Refer SAP notes 35952 and 70643. This is the normal behavior of the database and not an error, this problem can be rectified by reorganizing your database.

Award points accordingly,

Regards,

Raju.

Former Member
0 Kudos

Hi,

Did you delete the client use the transaction scc5?

If, yes,

Database size won't decrease. you have to decrease the tablespace size .

What database you are using?

Regards

Ben

Former Member
0 Kudos

Hi,

Yes, Sir client is deleted by SCC5 only...

I'm using Oracle 9I with Sun Solaris...

Need your Assistance for futher process..

Regards,

Neehir Bhatt

Former Member
0 Kudos