Re: saving contents of 6 tables simultaneously..

Nuno,

This might speed up the inserts (from link looks like it's the same as /*+ APPEND */ hint, but I still have a problem with having too many jobs running at once. In addition, running things in parallel might make the load worse.

On 1 Sep 2004 18:49:30 -0700, wizofoz2k_at_yahoo.com.au (Noons) wrote:

>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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Sep 02 2004 - 12:58:35 CDT