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 -> Re: insert into local table user select from remote db

Re: insert into local table user select from remote db

From: <zibinyang_at_gmail.com>
Date: 16 Feb 2005 10:38:11 -0800
Message-ID: <1108579091.480247.46030@l41g2000cwc.googlegroups.com>


You are right, it's insert take long time. I had tried both nologging and use append hint. they are same. I also tried use pl/sql to create a cursor to do this. does not change the fact.
the table is big. more then 10M records each. it's make me crazy.... Received on Wed Feb 16 2005 - 12:38:11 CST

Original text of this message

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