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: copy 2 big tables into one in oracle 9.2

Re: copy 2 big tables into one in oracle 9.2

From: Anurag Varma <avoracle_at_gmail.com>
Date: 4 Apr 2006 07:32:23 -0700
Message-ID: <1144161143.715060.93180@z34g2000cwc.googlegroups.com>

How big is big?

Try:
insert /*+ append */ into onetable select * from bigtable1;

Anurag Received on Tue Apr 04 2006 - 09:32:23 CDT

Original text of this message

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