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

Home -> Community -> Usenet -> c.d.o.misc -> Re: inserting many records with ADO is very slow

Re: inserting many records with ADO is very slow

From: wario <wario_spam_at_insightbb.com>
Date: 15 Sep 2004 11:34:30 -0700
Message-ID: <962c6d85.0409151034.746db556@posting.google.com>


Your example would not be the optimal method to perform bulk update/insert into a database.

  1. Create a pl/sql block to perform changes.

    begin

        execute immediate 'DROP   TABLE SCOTT.TEST';
        execute immediate 'CREATE TABLE SCOTT.TEST (NAME
VARCHAR2(750))';
        
        insert into scott.test  (name)
            select name  from table_a;

        commit;        

    end;

2. Better yet. Use SQL Loader to insert all your data into a table used for transactions. Then use MERGE, INSERT or UPDATE to update/insert changes to main table. Received on Wed Sep 15 2004 - 13:34:30 CDT

Original text of this message

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