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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ___________________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
