To
modify a single file in a tablespace:
Select the tablespace from the tree or the Tablespaces page that contains the file you want to modify. The properties of the tablespace will be displayed in the main window.

Click the Alter File button. The Alter File dialog box is displayed.

Note: The Alter File button is disabled until a file is highlighted in the Tablespace. The highlighted file will be altered.
Enter the number of pages you want to add to the file.
If you want to shrink the file by reducing the tailing free pages, select the Shrink File option button and enter the number of tailing free pages you want the file to contain.
Click the Check datafile before action check box if you want to check the consistency of the data file before altering the file.
Click the Confirm button. A message saying the file has been altered is displayed.
Click OK. The message clears.
Related topic: