GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 44 of 74    Print  

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.




  
Total Answers and Comments: 3 Last Update: March 15, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sujeshm
 
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.

Above answer was rated as good by the following members:
bhatnagar_neeraj
February 27, 2006 01:03:20   #1  
sujeshm Member Since: February 2006   Contribution: 3    

RE: What is a Data File ?
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.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 25, 2006 02:01:52   #2  
Priya        

RE: What is a Data File ?

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

Syntax :

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


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 15, 2007 05:41:58   #3  
sendhur        

RE: What is a Data File ?
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.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape