|Subject:||Tablespace best practices|
|Posted by:||Access (idmwarpzone_NOSPA…@yahoo.com)|
|Date:||Mon, 27 Dec 2004|
I was wondering what the "best practices" are regarding tablespace creation
- separate tablespaces for data/indexes ?
- separate tablespace for each schema ?
- large/medium/small objects in separate tablespaces ?
- locally managed with auto or manual segment space management ?
Just wanted to hear some pro/contra's ...