Before executing the activity, few items need to be consider,
• The data file must be empty
• You cannot remove the last data file in the DBspace. Instead, use DROP DBSPACE.
There are 2 ways of achieving this activity – using command-line or SAP Control Center (Wizard).
Using Command-Line
Use this command,
ALTER DBSPACE [DATABASE_NAME] DROP FILE [DATA_FILE_NAME], FILE [DATA_FILE_NAME]
Using SAP Control Center
1. Navigate to the following directory and double click on the DB Files. On your right panel, you will see the available list of data files.
IQ Servers > Space Management > DB Files
2. Select on which data file to be delete and click Delete.
