Re: saving contents of 6 tables simultaneously..

netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<41360fed.603498575_at_localhost>...
> 6 jobs). However, the problem I think is going to be 'fetching' from a
> cursor, instead of just doing a insert into .. select *.. and is going
> to be slower, is there are a way to speed it up? Is there are a 'bulk
> insert' from a cursor?
>
> Thanks!
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes

Hi Comrade.
Go here:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c21dlins.htm#365 for direct load with parallel. That might be the solution given that you are in 8ir3.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Sep 01 2004 - 20:49:30 CDT