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.

Data file structure[edit]

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;

Also see[edit]