Upgarde - Oracle: Deleting Tablespaces
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
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)|
Aidan McKiernan replied
Regarding your question, it is a known issue:
Did you create these tablespaces manually in prepare phase?
This problem is described in note 819655. As the tablespaces are empty,
you can drop them by using brspace.