SAP Knowledge Base Article - Preview

2498360 - Housekeeping Unused or Old Tablespace

Symptom

This article will show you what to do in case you want to perform a housekeeping on the unused or old tablespace to regain the freespace at disk level. 

Example:

  • In the DB02 -> Tablespaces -> Overview or DBACOCKPIT -> Space -> Tablespaces -> Overview, there is unused or old tablespace with 0% used existing in your database.
  • After system upgrade, old tablespaces with the old release name, example PSAP<SID>620 and PSAP<SID>700 exist at the database.


Read more...

Environment

  • SAP release independent
  • Oracle release independent

Keywords

drop unused tablespace, housekeeping old tablespace, -f tsdrop, drop tablespace, drop empty tablespace , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-DBA , Database Administration , How To

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.