use of tablespaces in oracle
From: Mike Prompovitch <prompom_at_mcln.unisysgsg.com>
Date: 1995/08/07
Message-ID: <DCy5z4.1r2_at_HAN.UnisysGSG.COM>#1/1
Date: 1995/08/07
Message-ID: <DCy5z4.1r2_at_HAN.UnisysGSG.COM>#1/1
I have a question on the use of tablespaces in Oracle. We are developing some new applications in Oracle, and being new to the product have gone to Oracle training. Unfortunatly, we have gone at different times and recived contradictory advice from the instructors. In this case one instructor said to create a separate tablespace for each table in the database. The other said that tablespaces are logical areas and that the tables should be grouped in tablespaces based on how they are used. This instructor also said that indexes should be placed in a single tablespace to reduce the administration effort due to the high degree of fragmentation caused by indexes.