Gurmeet Singh

• Feb 13th, 2006

 

use of tableapce in oracle are:1) we can assign different quotas to the user of databasae2)we can take a part of database unavailable from the user3)we can create a object which have block size different from standard block size4) we can take backup of part of the database

innovative

 Profile Answers by innovative Questions by innovative

• Feb 20th, 2006

 

tablespaces are the logical constructs which are group of datafiles. a datafile belongs to one database. in laymans language we can say that tablespaces are like folders in windows environment. as we create diff folders to store files in the same way tablespaces are used to store datafiles. we create diff. folders to store diff files in the same way we must create diff tablespaces to accomodate diff kind of datafiles(undo,temporary,user etc.)