"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:uhj77gl5qg0098_at_corp.supernews.com...
> As Mr Kyte recently point out, the table must be in
> Nologging mode in order not to generate
> REDO or rollback when using the APPEND Hint.
Nologging applies to redo not to rollback/undo. My understanding (and
admittedly you've now made me question it) is that *undo* is skipped on
direct load. In anycase there is nothing to stop you altering the table
nologging before a batch load of this type assuming you'll take a backup
afterward.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Jun 26 2002 - 08:58:40 CDT
