Re: partition tables

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Fri, 31 May 2002 06:23:47 -0800
Message-ID: <F001.00470C2D.20020531062347@fatcity.com>

You can use insert select , export/import, create as select to move data from a non-partitionned to a partitionned table.

Partitionning helps in the management of large tables more than in speeding the queries.
Will you delete data from that table one day ? Choose the partition key carefully.

A partition with only 100 000 rows is pretty small. Since you have 10 000 000 rows in your table, you will have 100 partitions of 100 000 rows, it's way too many small partitions.

• BigP <big_planet_2000_at_hotmail.com> a écrit : > Hi All ,
  > We are thinking of converting one of huge table in
  > to partition table . What is best way to achieve
  > this ? Is there any alter table clause that can do
  > this or I will have to export ..recreate table with
  > partition option and then import . Also how can I
  > mentiod that partition should have only 100000 rows
  > . For example after each 100000 rows add another
  > partition ?
  > If I have 10000000 rows in the table , should I
  > expect some performance gain out of this
  >
  > Thanks ,
  > BigP
  >
  >
  >
  

  ---

Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com

---

Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Fri May 31 2002 - 09:23:47 CDT