| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Manty tablepsaces in a small database
Hi,
I've been caught in this small database project. My question is do you create many tablespaces to separate tables, indexes, the different repositories stored in the db,... For now, there is more trouble than any gain.
For example, this a dss system with fact and dimension
tables. Usually the fact tables are huge and have
their own tablespaces or each partition has its own
tablespace. This time, I can put everything in 1
tablespace.
Also, since it's small, I do not have many independant
mount points so what is the gain of using many
tablepsaces ?
A bored dba
TIA
 |
 |