tablespace SAP<SID>640 after upgrade

[Former Member]

We have upgraded our XI dev system to NWSR2 PI 7.0.

As a part of the upgrade, created a table space <b>SAP<SID>700</b>, which as the name says is a replacement for <b>SAP<SID>640</b>.

What happens to the tablespace <b>SAP<SID>640</b> after upgrade?

In DB02, tablespace <b>SAP<SID>640</b> is totally free. 11Gbs of 11Gbs is free.

Can we drop this tablespace.

thanks,

-naveen.

[nick_fedorov]

Hi, Naveen.

Yes, you can drop tablespace PSAP<SID><source release> after upgrade.

if you are using oracle, you can start the following command as user ora<sapsid> :

brspace –f tsdrop

BRSPACE executes the drop command on the database and deletes the data files if the tablespace is empty.

Regards, Nick.

[Former Member]

Nick,

I kind of know that we can drop this tablespace.

But are there any checks that we have to do before we drop it.

Is there any documentation or notes by SAP.

reg,

[Former Member]

Naveen

You can drop the table space after the upgrade as mentioned by Nick .

Procedure:

Start the program BRSPACE at the operating system level as user ora<sapsid> with the following command:

brspace –f tsdrop

2. Choose Drop tablespace.

3. Select the tablespace you want to delete.

4. Choose Continue to drop the tablespace.

If the tablespace is empty, BRSPACE executes the drop command on the database and deletes the data files at the operating system level.

You can see this in the upgrade guide

Thanks

Prince Jose