Oracle Server Manager User's Guide

The Datafiles Folder

When you click the Datafiles folder tab, the Datafiles folder opens and the Datafile object list and menu appear. The Datafile object list contains information about the datafiles in your database.

For information about datafiles, see the Oracle7 Server Concepts and the Oracle7 Server Administrator's Guide.

The following figure illustrates the Datafile object list.

Figure 3 - 14. Datafile Object List

Datafile Object List

The columns of the Datafile object list are described below:

Filename Name of the datafile.
Tablespace Tablespace to which the datafile belongs.
Status Status of the datafile: Available or Invalid.
Size (K) Size of the datafile in kilobytes.

Creating a Datafile

To create a new datafile, choose Create from the Datafile menu. The Create Datafile property sheet appears. The Create Datafile property sheet consists of one page, called the Datafile Specification page.

The following figure illustrates the Datafile Specification page.

Figure 3 - 15. Datafile Specification Page of the Create Datafile Property Sheet

Datafile Specification Page

The Datafile Specification page of the Create Datafile property sheet is described below:

Tablespace Name of the tablespace to which the new datafile belongs.
Use the pop-up menu to choose the tablespace.
Filename Name of the datafile to be created.
Enter the name of the new datafile. The filename must be specified according to the conventions of your operating system.
Find File Displays the standard file selection dialog box for your system, which you can use to select a local file. Remote files cannot be seen.
Use Existing File Designates that the datafile already exists and should be reused.
New File Size Designates that Oracle should create the file.
Enter the size of the new datafile. Use the pop-up menu to specify either kilobytes or megabytes.

Renaming a Datafile

To rename an existing datafile, select the datafile to be renamed from the Datafile object list and choose Rename from the Datafile menu. The Rename Datafile dialog box appears. You can also bring up the Rename Datafile dialog box by double-clicking on the datafile in the Datafile object list.

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.

The following figure illustrates the Rename Datafile dialog box.

Figure 3 - 16. Rename Datafile Dialog Box

Rename Datafile Dialog Box

The Rename Datafile dialog box is described below:

From Old filename.
To New filename.
Enter the new filename. The filename must be specified according to the conventions of your operating system.

Attention: When you rename a datafile using Server 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 Server Manager, you must change the name of the file through your operating system.

Filename	Name of the datafile.
Tablespace	Tablespace to which the datafile belongs.
Status	Status of the datafile: Available or Invalid.
Size (K)	Size of the datafile in kilobytes.

Tablespace	Name of the tablespace to which the new datafile belongs.
	Use the pop-up menu to choose the tablespace.
Filename	Name of the datafile to be created.
	Enter the name of the new datafile. The filename must be specified according to the conventions of your operating system.
Find File	Displays the standard file selection dialog box for your system, which you can use to select a local file. Remote files cannot be seen.
Use Existing File	Designates that the datafile already exists and should be reused.
New File Size	Designates that Oracle should create the file.
	Enter the size of the new datafile. Use the pop-up menu to specify either kilobytes or megabytes.

From	Old filename.
To	New filename.
	Enter the new filename. The filename must be specified according to the conventions of your operating system.