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