Hi Yong,
I don't think that's right. Try it on a table with no indexes, and dump
the redo and undo blocks afterwards. My tests show that there is no row
level redo (layer 11) except against the data dictionary tables for
space management, regardless of whether the table or tablespace is
defined
Hi, Connor,
The append hint to insert does not disable generating rollback info. It does
stop redo generation for a nologging table.
Yong Huang
[EMAIL PROTECTED]
you wrote:
If you're on 8.0 or higher, try
insert /*+ APPEND */
into table
select * from other_table;
where "table" is defined as