Re: One db too many
From: EdwardP <member_at_dbforums.com>
Date: 14 Jan 2002 16:14:19 -0500
Message-ID: <3c434a2b$1_at_usenetgateway.com>
Date: 14 Jan 2002 16:14:19 -0500
Message-ID: <3c434a2b$1_at_usenetgateway.com>
Hi,
How about:
4) split your inserts [WHERE IN (x,y,z,...)] into chunks of 1000 ids
5) instead of using array, save your IDs in a file and use Oracle
SQLoader
-Edward
--
Posted via dBforums
http://dbforums.com
Received on Mon Jan 14 2002 - 22:14:19 CET