Re: copy 2 big tables into one in oracle 9.2

Anurag Varma wrote:

> How big is big?

30 Million rows, each row with about 15 fields, most of them varchar.

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

What is the append-hint doing? Received on Tue Apr 04 2006 - 09:35:29 CDT