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 as NOLOGGING. The undo is correspondingly trivial. However, if
there are indexes then you get lots of index redo (layer 10) and
corresponding undo.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-----Original Message-----
Sent: Sunday, 25 March 2001 15:18
To: Multiple recipients of list ORACLE-L
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 nologging. Then you won't
hit either redo logs or rollback segments..Its the
equivalent of a sqlldr direct load
hth
connor
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Adams
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
