EhP6 Post-Update: Oracle Tablespaces

[Former Member]

Hi

After an ERP EhP6 (NW731) Update from EhP4 (NW701) the tablespace PSAPSR3701 is left behind, only containing about 10 segments starting with TTREE... which use about 500MB of space (Windows 2008R2, SAP Kernel 720_EXT 401, Oracle 11.2.0.3)

If possible, I would like to get rid of the tablespace PSAPSR3701.

How exactly can I do that? Is it safe?

Because I'm curious:

Why is the tablespace left behind  and why does it still contain data that's also needed in NW731? Bug or feature?

Regards,

Michael

[former_member188883 · Accepted solution]

Hi Michael,

During upgrade from one version to another, you shall find empty tablespace of source version. You may drop it once the upgrade is successfully completed.

Ideally these tablespaces should not contain any data as all data should get migrated to new tablespace during the upgrade.

Regards,

Deepak Kori

[former_member188883 · Accepted solution]

Hi Michael,

Also refer following link for issues similar to yours. It is basically a result of inconsistency between IAORA and TAORA tables. These tables contain information about segment -> tablespace mapping.

http://scn.sap.com/thread/3294166

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thank you!

[Former Member · Accepted solution]

Solution was:

Shutdown SAP

Reorg Tables with BRTools from Tablespace PSAPSR3701 to PSAPSR3731

Drop Tablespace

Start SAP

Data class is the same as in reference system, so everything looks correct.

[Former Member]

By Command

su - orasid

brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPPRD700 -t "*" -parallel 3 -degree 3 -newts PSAPSR3731