SAP Knowledge Base Article - Preview

3698290 - BR1324W SAP table data class (tabart) '*****' of owner SAPSR3 is referencing the dropped tablespace PSAPSR3750X

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

SAP ERP 6.0

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.