Skip to Content
Previous

Dropping a Dbspace File

By joannaluSAP

2 methods to drop a Dbspace file

You will learn

  • How to drop a Dbspace file using HANA Cockpit
  • How to drop a Dbspace file using a SQL Command

Details


Step 1: Dropping a Dbspace File

Dropping Dbspace files can be done from both SAP HANA Cockpit and HANA Studio.

In this tutorial, we will be dropping the files from Cockpit. Similarly to the previous tutorial, scroll to the Dynamic Tiering section in the tenant overview page, and select “Manage Dynamic Tiering Dbspaces” under the Dynamic Tiering Links of your HANA Cockpit.

We can drop the Dbspace file that we just created in the previous tutorials by first selecting the ES_USER and click Edit in the bottom-right corner.

Edit Dbspace

Click the red X button next to ES_USER_FILE1. A pop-up dialogue box will appear confirming the deletion of the Dbspace file. Click “OK” to delete the file.

Step 2: SQL Command to Drop a Dbspace File

Note: You can also delete the Dbspace file using HANA Studio (through the System Database) by running a SQL command:

ALTER TABLE EXTENDED STORAGE ALTER DBSPACE ES_USER DROP FILE "ES_USER_FILE1";

Updated 09/20/2017

Time to Complete

10 Min

Beginner

Prerequisites

  • Tutorials Enlarging a Dbspace File Using Reserved Space
Next
Back to top

Call me now