Re: Insert Into Select From Question

You can not ask ORACLE not to use rollback segment. To move large amount of data you can try using direct load insert by using the "APPEND" hint and disable logging for the destination table. Beware though, the table is unrecoverable once you disable the logging.

• Jusung Yang

"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message news:<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 - 21:06:31 CET