Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disable logging in tablespace vs using hidden parameter _disable_logging

Re: Disable logging in tablespace vs using hidden parameter _disable_logging

From: Li-Shan Cheng <exriscer_at_gmail.com>
Date: Thu, 2 Feb 2006 18:34:35 +0100
Message-ID: <6e9345580602020934i19551094x68b79595d5deac54@mail.gmail.com>


Well they are not the samething to start with.

NOLOGGING only works for direct load operations, index rebuilds etc (there are more)

_disable_logging means no redo whatsoever

On 2/2/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> Hi I was asking my self, and I decided to ask people who knows better
> about it:
>
> Which is the difference if I set all tablespace to nologging vs
> if I set the hidden parameter to disable logging _disable_logging.
> To get an import to development environment faster.
>
> I know I can't recover if there is a problem, etc, etc. The question
> is which is the real difference.
>
> .) Thank you
> --
> Oracle Certified Profesional 9i 10g
> Orace Certified Professional Developer 6i
>
> 8 years of experience in Oracle 7,8i,9i,10g and developer 6i
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2006 - 11:34:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US