Re: Tablespace best practices

From: Dave <x_at_x.com>
Date: Mon, 27 Dec 2004 00:21:15 GMT
Message-ID: <%zIzd.7451$Ar5.3882@text.news.blueyonder.co.uk>

"Access" <idmwarpzone_NOSPAM__at_yahoo.com> wrote in message news:41cf4475$0$339$ba620e4c_at_news.skynet.be...
> Hi,
>
> I was wondering what the "best practices" are regarding tablespace
> creation
> :
> - separate tablespaces for data/indexes ?

nope, no need
> - separate tablespace for each schema ?

not a bad idea - for manageability
> - large/medium/small objects in separate tablespaces ?

not a bad idea, depends how wildly your sizes vary
> - locally managed with auto or manual segment space management ?

up to you, auto works fine if you dont care that much

>
> Just wanted to hear some pro/contra's ...
>
>
>
>
Received on Sun Dec 26 2004 - 18:21:15 CST