Datafile Property Sheet: General Page

The General page of the Datafile property sheet allows you to modify existing datafile parameters or create a new datafile when the Create menu option is selected from the Datafile object (right-mouse) or the Object menu.

Note: When altering a tablespace, the fields on this page cannot be modified if the datafile belongs to a read-only tablespace.

Name

Name of the datafile to be created. Enter the file and path name of the new datafile. The filename must be specified according to the conventions of your operating system. When altering an existing datafile, you can rename the datafile by typing in a new name.

You must rename a datafile if you have changed the name of the corresponding operating system file or if you have moved the file to a new location. To rename a datafile, its tablespace must be offline.

When you rename a datafile using Storage Manager, the name of the operating system file is not changed. The new filename is only associated with the tablespace. Before renaming the datafile using Storage Manager, you must change the name of the file through your operating system.

Tablespace

Name of the tablespace to which the new datafile belongs. Use the drop-down list to choose the tablespace. You can only choose the tablespace when the datafile is created.

Status

Online: Specifies that the datafile be placed online.

Offline: Specifies that the datafile be place offline.

Note: When adding a datafile to either a new or existing tablespace, the Online and Offline option will be disabled. When altering a tablespace, the fields on this page cannot be modified if the datafile belongs to a read-only tablespace.

To determine the file size, select either the Use Existing File or New File Size option.

Size

File Size: Allows you to designate the file size of a new or existing file. Enter the size of the new or existing datafile. Use the unit buttons to specify either kilobytes or megabytes.

Reuse Existing File: Designates that the datafile already exists and should be reused.