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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 25 Sep 2002 11:38:32 -0800
Message-ID: <F001.004D923D.20020925113832@fatcity.com>

Robert - That is how I've generally done it. If you are partitioning because the table is very large, then separate tablespaces gives you the flexibility to place these partitions on separate devices so you can get some parallel I/O going.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----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?

RF

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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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). Received on Wed Sep 25 2002 - 14:38:32 CDT