Re: Logging

There is an /*+ APPEND */ hint which allows for NOLOGGING inserts in much the same
way that SQL*Load direct mode does -
i.e. inserts above the highwater mark, then moves the high water mark.

This is VERY restrictive, and may not be at all appropriate for your needs.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Harris wrote in message <37724373.B3EB041_at_res.raytheon.com>...
>Is there any way to turn ALL logging off? In the oracle8 documentation,
>it says the NOLOGGING option does not affect INSERT...values
>statementes, which is all that I am doing! We are trying to get very
>quick response times, and hopefully turning off logging may help.
>
Received on Thu Jun 24 1999 - 16:10:11 CDT