Skip to Content
avatar image
Former Member

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


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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 15, 2013 at 01:28 PM

    Dear Ashish,

    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.



    Add comment
    10|10000 characters needed characters exceeded

    • 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.


      Deepak Kori

  • Oct 15, 2013 at 01:59 PM


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

    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.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2013 at 01:44 PM


    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.

    Do not delete until you complete the upgrade.


    Add comment
    10|10000 characters needed characters exceeded