What is a Data File ?

Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

Interview Candidate
Sep 5th, 2004
3
1809

Concepts and Architecture

Answer

Showing Answers 1 - 3 of 3 Answers

sujeshm
Profile Answers by sujeshm

Feb 27th, 2006

the data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space.

Priya

Sep 25th, 2006

Actually we can alter the size of the datafile by using the below syntax

Syntax :
ALTER DATABASE DATAFILE <DATAFILENAME> RESIZE <NEW SIZE>;

sendhur

Mar 15th, 2007

the data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space.