4.204 DBA_DATA_FILES
DBA_DATA_FILES
describes database files.
Note:
When you query the DBA_DATA_FILES
data dictionary view, Oracle must have access to all tablespaces and their data files if the requested information is not already available in the dictionary. If the tablespaces are encrypted, then you must open the Oracle wallet (keystore) before you can query DBA_DATA_FILES
. You can use the ADMINISTER
KEY
MANAGEMENT
SET
KEYSTORE
OPEN
statement to open the keystore.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the database file |
|
|
|
File identifier number of the database file |
|
|
|
Name of the tablespace to which the file belongs |
|
|
|
Size of the file in bytes |
|
|
|
Size of the file in Oracle blocks |
|
|
|
File status: |
|
|
|
Relative file number |
|
|
|
Autoextensible indicator |
|
|
|
Maximum file size in bytes |
|
|
|
Maximum file size in blocks |
|
|
|
Number of Oracle blocks used as autoextension increment |
|
|
|
The size of the file available for user data. The actual size of the file minus the |
|
|
|
Number of blocks which can be used by the data |
|
|
|
Online status of the file:
|
|
|
|
Lost write protection status of the file. Possible values:
If lost write protection is enabled for a single data file, it does not have to be enabled for another data file in the same tablespace. If lost write protection is enabled for a tablespace, it is enabled for all data files for that tablespace, including data files added later. You can check the lost write protection status for a tablespace by querying the |
See Also:
-
Oracle Database Advanced Security Guide for information on opening a software keystore
-
Oracle Database Advanced Security Guide for information on opening a hardware keystore