cancel
Showing results for 
Search instead for 
Did you mean: 

Upgarde - Oracle: Deleting Tablespaces

ashish_vikas
Active Contributor
0 Kudos

Dear friends,

We had just performed a upgrade from 4.6C > EHP6 for ECC6. After this, i am having many tablespaces in my system

as per upgrade guide - section 6.18Oracle: Deleting Tablespaces > says we can delete PSAP<SCHEMA-ID><source release> tablespace.. means

PSAPSR346C.

I need to know about PSAPDIMD, PSAPDIMI, PSAPFACTD, PSAPFACTI, PSAPODSD & PSAPODSI.. can they be dropped as well ? They also have no objects in it.

Tablespace                   Size (kb)  Free (kb)

PSAPDIMD                         204.800    203.776
PSAPDIMI                         204.800    203.776
PSAPFACTD                        204.800    203.776
PSAPFACTI                        204.800    203.776
PSAPODSD                         204.800    203.776
PSAPODSI                         204.800    203.776
PSAPSR3                      512.614.400 21.735.360
PSAPSR346C                    20.992.000 20.991.680
PSAPSR3731                    58.777.600  1.532.608
PSAPSR3USR                    21.770.240  4.445.056
PSAPTEMP                       6.144.000  6.144.000
PSAPUNDO                       9.523.200  9.414.080
SYSAUX                           716.800     59.328
SYSTEM                         1.863.680      4.928

best regards

ashish

Accepted Solutions (1)

Accepted Solutions (1)

former_member264034
Active Contributor
0 Kudos

Dear Ashish,

Regarding your question, it is a known issue:

Did you create these tablespaces manually in prepare phase?

PSAPDIMD
PSAPDIMI
PSAPFACTD
PSAPFACTI
PSAPODSD
PSAPODSI

This problem is described in note 819655. As the tablespaces are empty,
you can drop them by using brspace.

Regards,

Aidan

ashish_vikas
Active Contributor
0 Kudos

yes I created them in prepare phase.. I will read note 819655 and will let you know. Thanks.

former_member188883
Active Contributor
0 Kudos

Hi Ashish,

The tablespaces PSAPDIMD, PSAPDIMI, PSAPFACTD, PSAPFACTI, PSAPODSD & PSAPODSI gets created as a part of R3load export/import process. SQL files are generated using the report SMIGR_CREATE_DDL before the export and during the import these SQL files are being used to create these tablespaces in the target system.,

So wanted to understand whether this report was being used in your system ?

If not, then u may delete these tablespaces as these are related to BI objects only not relevant to ECC application.

Hope this helps.

Regards,

Deepak Kori

Answers (2)

Answers (2)

Reagan
Advisor
Advisor
0 Kudos

Hello

As you were on 4.6C the tablespace names should have been according to this link

http://help.sap.com/saphelp_46c/helpdata/en/0d/d2f7d04a0c11d182b80000e829fbfe/content.htm

For EHP6 the tablespace PSAPSR3731 will be the one used.

I would take a full backup of the upgraded system and drop the old data and index tablespaces based on the old layout (PSAPDIMD PSAPDIMI PSAPFACTD PSAPFACTI PSAPODSD PSAPODSI)

If there are any objects then move them to the PSAPSR3731 tablespace before you drop.

Regards

RB

Former Member
0 Kudos

Hi,

Yes you need not do anything in your old tablespace, For new one created you have to extend the table space.

Follow the note:

OSS 1493932 - DB6: How to choose the extent size of DB2 tablespaces.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f03d5fb8-b619-2b10-c383-c6d568728....

Do not delete until you complete the upgrade.

BR,
Prabhakar