Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> INSERT millions_of_rows, how to COMMIT every 10,000 rows ?

INSERT millions_of_rows, how to COMMIT every 10,000 rows ?

From: <xtanto_at_hotmail.com>
Date: 27 Mar 2005 05:43:53 -0800
Message-ID: <1111931033.824086.310730@o13g2000cwo.googlegroups.com> 





Hi All,



I want to insert millions of rows from old table into new table.
(different in structure, so that I have manipulate in the query)



INSERT INTO [new table] SELECT ... FROM [old table]



How can I do COMMIT for every 10,000 rows ?



Thank you for your help,


Krist
Received on Sun Mar 27 2005 - 07:43:53 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US