GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL Plus
Go To First  |  Previous Question  |  Next Question 
 SQL Plus  |  Question 50 of 132    Print  
What are the different tablespaces in database

  
Total Answers and Comments: 5 Last Update: September 21, 2006   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 10, 2005 08:19:57   #1  
Vijay        

RE: What are the different tablespaces in database
Locally Managed Tablespaces
Dictionary Managed Tablespaces
System Tablespace
Temporary Tablespace

 
Is this answer useful? Yes | No
January 07, 2006 21:08:25   #2  
Shasi        

RE: What are the different tablespaces in database

I would like to add one more to the previous reply

1. undo tablespace


 
Is this answer useful? Yes | No
March 17, 2006 03:28:50   #3  
michelle        

RE: What are the different tablespaces in database

Hi

can anyone explain about tablespace? i read the notes of tablespace but still not understand on the tableapace and datafile.

Thanx


 
Is this answer useful? Yes | No
March 24, 2006 11:19:47   #4  
na123 Member Since: March 2006   Contribution: 10    

RE: What are the different tablespaces in database

A tablespace is a collection of one or more datafiles.all database objects are stored in tablespaces.

diff types of tablespaces:-

1)system tablespace.

2)temp tablespace.

3)tools tablespace

4)users tablespace.

5)rollback tablespace.

6)data and index tablespace.


 
Is this answer useful? Yes | No
September 21, 2006 09:03:24   #5  
Neelkanth        

RE: What are the different tablespaces in database

There are only three tablespaces as follows:-

1.Permanent tablespace

2.Undo tablespace

3.Temperory tablespace


 
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