Re: Newbie: Creating new database files

jim_at_ponder-stibbons.com says...

> Muldoon <geoff.muldoon_at_trap.gmail.com> writes
> > But *why* you'd bother
> >to set up separate tablespaces for each schema/user (read that as each
> >"database" in Access terms) just to simulate what you used to do in Access
> >is the real question. I can't think of a decent reason why you would.
> >
> Separating applications by tablespace is a very common practice.

Commonly done doesn't necessarily mean sensibly done. I've seen similar debates here about the supposed benefits of separating tables and indexes into separate tablespaces. Advantages of separate tablespaces per app?

Geoff M Received on Wed Nov 01 2006 - 16:23:07 CST