sri

• Aug 4th, 2005

 

Characterstics of Data File : 
- A Data file can be associated with only one database. 
- Once created, a data file cannot change is size. 
- One or more data files form a logical unit of database storage called a Tablespace.

Bahurudeen

• Oct 5th, 2005

 

 

Datafile size can be change by using ALTER DATABASE .................RESIZE command

deepikadba

 Profile Answers by deepikadba 

• Jun 6th, 2008

 

1.datafiles r used to store data
2.datafile can be resized but it can be increased in size but not shrinked

alex.v

 Profile Answers by alex.v Questions by alex.v

• Jul 11th, 2008

 

datafiles can be resized to a lower size also, but till the used space....

srinivasanram2004

 Profile Answers by srinivasanram2004 

• Jul 29th, 2008

 

Characteristics of a Data File :
- A Data file can be associated with only one tablespace.
- Once created, a datafile can be increased or decreased in size with RESIZE
command. Example: ALTER database datafile '/u03/oradata/dev01/users_02.dbf'
RESIZE 150 MB ;
- Once created, a datafile cannot be dropped. It can only be shrunk to an
insignificant size.
- One or more data files form a logical unit of database storage called a
Tablespace.

Ram Srinivasan