Are Inserts without generating Redo possible?
From: Don Hall <dhall_at_twoil.com>
Date: Wed, 23 Dec 1998 18:06:46 +0000
Message-ID: <36813136.BA1A2BF7_at_twoil.com>
I know that SQL Loader can be setup to do bulk loads with the direct path option to increase speed and minimize server overhead. My problem is I have a huge file with
variable length records that need to be loaded into two tables with a parent / child relationship. I have written a Pro Cobol to do the load but it is slow because it does 1000's of inserts and generates a lot of [Quoted] redo info. Is there a way do make this method of insertion like a direct path load? Received on Wed Dec 23 1998 - 19:06:46 CET
Date: Wed, 23 Dec 1998 18:06:46 +0000
Message-ID: <36813136.BA1A2BF7_at_twoil.com>
I know that SQL Loader can be setup to do bulk loads with the direct path option to increase speed and minimize server overhead. My problem is I have a huge file with
variable length records that need to be loaded into two tables with a parent / child relationship. I have written a Pro Cobol to do the load but it is slow because it does 1000's of inserts and generates a lot of [Quoted] redo info. Is there a way do make this method of insertion like a direct path load? Received on Wed Dec 23 1998 - 19:06:46 CET