|
|
| Re: default index tablespace [message #62754 is a reply to message #62753] |
Wed, 11 August 2004 12:47  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
no, you can only define a defualt tablespace and a default temporary TS.
There is an old-wives tale about needing separate Table and Index tablespaces. The sourse of the rumour was some oracle documentation advising that I/O should be spread across physical disks. You could also have opted to put objects A-K on disk1, J-S on another and T-Z on another. If your machines have SAN managed storage then logical mount points don't necessarily map to different disks and also a single mount point may the striped across multiple disks anyway.
Unless you know that you will be spreading I/O by creating multiple tablespaces, a single tablespace could be just fine. I'd still create on separate tablespaces for each significant application for improved space management and recovery purposes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
