Insert Into Select From Question
From: Rob Panosh <rob_panosh_at_asdsoftware.com>
Date: Tue, 28 Jan 2003 07:49:31 -0600
Message-ID: <3e368dbf$1_at_nntp01.splitrock.net>
Date: Tue, 28 Jan 2003 07:49:31 -0600
Message-ID: <3e368dbf$1_at_nntp01.splitrock.net>
Hello,
In my program at runtime I want to be able to move a large amouts of data from one table to another using "Insert Into myNewTable SELECT x, y, 'new column data' FROM myOldTable" without running into any rollback segment implications. Does anybody know how to tell the database to suppress the transaction? When the insert is done processing I will compare record counts to make sure the insert was successful.
Thanks,
Rob
Received on Tue Jan 28 2003 - 14:49:31 CET