on 10-15-2013 2:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes I created them in prepare phase.. I will read note 819655 and will let you know. Thanks.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Do not delete until you complete the upgrade.
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.