Re: Tablespace best practices

Comments in-line.

Access wrote:

> Hi,
>
> I was wondering what the "best practices" are regarding tablespace creation
> :
> - separate tablespaces for data/indexes ?

Waste of effort accomplishing nothing.

> - separate tablespace for each schema ?

Depends. Separate by application yes but by schema probably not.

> - large/medium/small objects in separate tablespaces ?

A good practice but not just because of the size.

> - locally managed with auto or manual segment space management ?

Absolutely unless you have something specific about your situation where you can demonstrate, by lab testing, that it is negatively impacting your application.

> Just wanted to hear some pro/contra's ...

I suggest separating domain tables, lookups, into read-only tablespaces. Back them up once or twice and then forget them until a change is made.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)