Insert Into Select From Question

[Rob Panosh]

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

[Jusung Yang]

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_p...@asdsoftware.com> wrote in message news:<3e368dbf$1...@nntp01.splitrock.net>...