Data file

From Oracle FAQ
(Redirected from Datafile)
Jump to: navigation, search

A data file is a file that is part of an Oracle database. Datafiles are used to store data - including user data and undo data. Data files are grouped together into tablespaces.

[edit] Data file structure

Query data file details:

SELECT * FROM v$datafile;
SELECT * FROM dba_data_files;

Create tablespace with datafile:

CREATE TABLESPACE ts1 DATAFILE '/u01/oradata/orcl_ts1_01.dbf' SIZE 100M;

Create an UNDO tablespace with datafile:

CREATE UNDO TABLESPACE undots1 DATAFILE '/u01/oradata/orcl_undots1_01.dbf' SIZE 100M;

[edit] Also see