Re: partitioned table-number of tablespaces (oracle 10g2)
From: Mladen Gogala <no_at_email.here.invalid>
Date: Thu, 16 Dec 2010 20:05:42 +0000 (UTC)
Message-ID: <pan.2010.12.16.20.05.42_at_email.here.invalid>
On Thu, 16 Dec 2010 03:55:40 -0800, Michał Jabłoński wrote:
Date: Thu, 16 Dec 2010 20:05:42 +0000 (UTC)
Message-ID: <pan.2010.12.16.20.05.42_at_email.here.invalid>
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.comReceived on Thu Dec 16 2010 - 14:05:42 CST