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 with Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.