Tablespace best practices

Giganews Newsgroups
Subject: Tablespace best practices
Posted by:  Access (idmwarpzone_NOSPA…@yahoo.com)
Date: Mon, 27 Dec 2004

Hi,

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 ...

Replies