cancel
Showing results for 
Search instead for 
Did you mean: 

Client delete space

Former Member
0 Kudos

Hi,

We are almost doing production go-live activities. During this process we have created new client in production 600 and did local client copy SAP_CUST from original client 500. After that we have deleted original client using SCC5.

Even we have deleted the original client 500 we still see the space utilization.

After delete the client usng SCC5 how to get the free space.Do i need to reorganize the dataabse?

What all post steps i have to do after deleting the client.

- Kristsne

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Check note 646681 .

Thanks

Prince Jose

Answers (3)

Answers (3)

Former Member
0 Kudos

hi ,

we are using MS SQL 2005 64bit dataabse and ECC6.0 SR01 application.

I knew in oracle we can use brspace but in sql we can not use brspace.

what might the command and reorganize.

Former Member
0 Kudos

Hi Kristene,

AFAIK, there is no reorg utility like in Oracle/Informix/DB2 existed as the space allocation is controlled by the SQL engine automatically. It doesn't mean that you cannot reclaim the space though. For example you could use DTS to export/import data and recreate tables.

You can take a look at the following forum thread where similar question was raised:

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/reclaiming-unused-but-reserve...

Hope this helps,

Regards,

Mike

Former Member
0 Kudos

Tanuj ,

How to reorganize.Can you please suggest.

- Kristene

Former Member
0 Kudos

Hi,

You can claim that space only after reorganization.

Thanks,

Tanuj