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

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

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?

    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

    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.

      Regards,

      Deepak Kori

  • Oct 15, 2013 at 01:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    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-c6d56872829e?QuickLink=index&overridelayout=true&57518202036614.

    Do not delete until you complete the upgrade.

    BR,
    Prabhakar

    Add comment
    10|10000 characters needed characters exceeded