Re: partitioned table-number of tablespaces (oracle 10g2)

From: Michał Jabłoński <michal.jablonsk_at_gmail.com>
Date: Fri, 17 Dec 2010 02:33:52 -0800 (PST)
Message-ID: <9db8a5d1-6728-4622-9404-508d192a9584_at_32g2000yqz.googlegroups.com>

On 16 Gru, 21:05, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Thu, 16 Dec 2010 03:55:40 -0800, Michał Jabłoński wrote:
> > I've got non-partitioned table which I have to move to partitioned
> > table. I've decided to move it to hash partitioned table with 16
> > partitions. It is a good practice to create dedicated tablespace for
> > each partition with one datafile?
>
> What would you like to achieve by splitting table into different
> tablespaces, as opposed to splitting it into a single tablespace?
>
> --http://mgogala.byethost5.com

I think about performance, time of execution sql on this table. In this case it is better to create more tablespaces with one datafile or less with one or more datafiles? Or it doesn't matter? Received on Fri Dec 17 2010 - 04:33:52 CST