Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Upgarde - Oracle: Deleting Tablespaces

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

Former Member
Former Member replied

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

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question