Tablespace best practices

Giganews Newsgroups
Subject: Tablespace best practices
Posted by:  Access (idmwarpzone_NOSPA…
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 ...