Symptom
After system upgrade, tablespace PSAPSR3750X is still there. While dropping the empty tablespace PSAPSR3750X via BRTools getting bellow error:
BR0677I The action will be executed...
BR1324W SAP table data class (tabart) 'SLDEF' of owner SAPSR3 is referencing the dropped tablespace PSAPSR3750X
BR1324W SAP table data class (tabart) 'SLEXC' of owner SAPSR3 is referencing the dropped tablespace PSAPSR3750X
BR1324W SAP table data class (tabart) 'SSDEF' of owner SAPSR3 is referencing the dropped tablespace PSAPSR3750X
BR1324W SAP table data class (tabart) 'SSEXC' of owner SAPSR3 is referencing the dropped tablespace PSAPSR3750X
The TAORA, IAORA tables still has entries of the dropped PSAPSR3750X tablespace for few dataclass (TABART)
TAORA
------------------------------------------------------------------
|TABART|TABSPACE |PCTINC|OFREELIST|OFREEGROUP|OPCTFREE|OPCTUSED|
------------------------------------------------------------------
|SLDEF |PSAPSR3750X|0000 |001 |01 |10 |40 |
|SLEXC |PSAPSR3750X|0000 |001 |01 |10 |40 |
|SSDEF |PSAPSR3750X|0000 |001 |01 |10 |40 |
|SSEXC |PSAPSR3750X|0000 |001 |01 |10 |40 |
--------------------------------------------------------------------
IAORA
----------------------------------------------
|TABART|TABSPACE |PCTINC|OFREELIST|OPCTFREE|
----------------------------------------------
|SLDEF |PSAPSR3750X|0000 |001 |10 |
|SLEXC |PSAPSR3750X|0000 |001 |10 |
|SSDEF |PSAPSR3750X|0000 |001 |10 |
|SSEXC |PSAPSR3750X|0000 |001 |10 |
--------------------------------------------------
The TSORA table however has no entry of the dropped PSAPSR3750X tablespace
TSORA
-------------------------
|TABSPACE |INDSPACE |
-------------------------
|PSAPSR3 |PSAPSR3 |
|PSAPSR3750 |PSAPSR3750 |
|PSAPSR3FACT|PSAPSR3FACT|
|PSAPSR3ODS |PSAPSR3ODS |
|PSAPSR3USR |PSAPSR3USR |
There are still some DB objects with those dataclass
SELECT count(*) FROM DD09L WHERE TABART IN ('SLDEF','SLEXC','SSDEF','SSEXC');
>36 rows selected
Read more...
Environment
Oracle version: Oracle 19c
Product version: SAP ERP 6.0
Product
Keywords
PSAPSR3750X, BR1324W, tabart, SLDEF, SLEXC, SSDEF, SSEXC, how to, SE16, TAORA, IAORA, TSORA, DD09L , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview