RE: Best Practice - Partitioned object, one partition per tablesp

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 25 Sep 2002 11:53:33 -0800
Message-ID: <F001.004D92FB.20020925115333@fatcity.com>

That's the strategy I have followed in my databases. Each table partition and each index partition is in its own tablespace. Helps me a lot when I do any maintenance operations. Partitioning is by 4 digit calendar year.

Kirti

-----Original Message-----
Sent: Wednesday, September 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L tablespace,

We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share?

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!

The avalanche has begun, It is too late for the pebbles to vote.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------