Re: partitioned table-number of tablespaces (oracle 10g2)
Date: Thu, 16 Dec 2010 07:37:35 -0800 (PST)
Message-ID: <24d91d2f-e5ec-4805-8646-d8a924cce094_at_r16g2000prh.googlegroups.com>
On Dec 16, 6:55 am, Michał Jabłoński <michal.jablo..._at_gmail.com> 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 practise to create dedicated tablespace for
> each partition with one datafile?
If you assign each partition to its own tablespace probably should be based on expected partition size and your space management policies and backup/restore plan.
If each partition is only a couple of gigabytes and you use 32G files then assigning each partition to its own tablespace seems overkill. On the other hand if each is around 20g and you like to keep all your tablespaces close to the same size for restore of any tablespace takes about the same amount of time as restoring any other tablespace then you may want to split them up. You may determine that assigning two to four partitions to the same tablespace makes the most sense.
It is a matter of preference, not best practice.
HTH -- Mark D Powell -- Received on Thu Dec 16 2010 - 09:37:35 CST