<< Click to Display Table of Contents >>

Datafiles

Top Previous Next

The list displays all datafiles in the database:

ID of the datafile

Tablespace name

File name

Size in Kbytes

Free space in Kbytes

Usage (%)

Allocable (Kbytes)

File status: INVALID or AVAILABLE

Auto extensible indicator: YES or NO

Maximum size of the file in Kbytes

Next (Kbytes)

Number of fragments

Size of the largest free chunk

Size of the smallest free chunk

Backup file status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error

Backup change number: System change number when backup started

Backup time: Time the backup started

The following context operations are available:

TblSpaceAddFile

Add data file

 

 

Shows a modal dialog for adding a new datafile to the tablespace.

07_Drop

Offline drop

 

 

Executes the ALTER TABLESPACE xxx OFFLINE DROP. Attention: This does not drop the datafile. You must run media recovery after executing this command! See Oracle documentation for further details.

 

Change status

Enable

Online

Switches the data file online.

 

 

DISABLE

Offline

Switches the data file offline.

TblSpaceRenameFile

Rename

 

 

Renames the data file.

05_Properties

Properties/Resize

 

 

Shows a modal dialog for viewing and modifying properties of the data file. You can also resize the datafile.

 

Grid View

 

 

For more information, see object window