DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=ZfsaHd5ccExtyswzGMy8cDfr6EipHPsCIqTocu34uVrWkN62nZYCgtXuthv1W47t88B6H0BlTqNSIcBlV6oLLBdUfb9VhBSCtrt5CtM/dd9kMtD0WeulhcaWyjYfoVYkLXkKy+tsjRiTfrWZw6EwjoGJYlJKpmzw1T2ZzqrMfX0=
Message-ID: <6e9345580602020934i19551094x68b79595d5deac54@mail.gmail.com>
Date: Thu, 2 Feb 2006 18:34:35 +0100
From: Li-Shan Cheng <exriscer@gmail.com>
To: juancarlosreyesp@gmail.com
Subject: Re: Disable logging in tablespace vs using hidden parameter _disable_logging
Cc: oracle-l@freelists.org
In-Reply-To: <cd4305c10602020927s49be7a3ue231fee12307e332@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_5448_28646580.1138901675748"
References: <cd4305c10602020927s49be7a3ue231fee12307e332@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: exriscer@gmail.com
------=_Part_5448_28646580.1138901675748
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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@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
>
>
>

------=_Part_5448_28646580.1138901675748
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Well they are not the samething to start with. <br><br><br>NOLOGGING only w=
orks for direct load operations, index rebuilds etc (there are more)<br><br=
><br>_disable_logging means no redo whatsoever<br><br><br><br><br><div><spa=
n class=3D"gmail_quote">
On 2/2/06, <b class=3D"gmail_sendername">Juan Carlos Reyes Pacheco</b> &lt;=
<a href=3D"mailto:juancarlosreyesp@gmail.com">juancarlosreyesp@gmail.com</a=
>&gt; wrote:</span><blockquote class=3D"gmail_quote" style=3D"border-left: =
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;=
">
Hi I was asking my self, and I decided to ask people who knows better about=
 it:<br><br>Which is the difference if I set all tablespace to nologging&nb=
sp;&nbsp;&nbsp;&nbsp;vs<br>if I set the hidden parameter to disable logging=
&nbsp;&nbsp;_disable_logging.
<br>To get an import to development environment faster.<br><br>I know I can=
't recover if there is a problem, etc, etc. The question<br>is which is the=
 real difference.<br><br>.)&nbsp;&nbsp;Thank you<br>--<br>Oracle Certified =
Profesional 9i 10g
<br>Orace Certified Professional Developer 6i<br><br>8 years of experience =
in Oracle 7,8i,9i,10g and developer 6i<br>--<br><a href=3D"http://www.freel=
ists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br=
>
<br><br></blockquote></div><br>

------=_Part_5448_28646580.1138901675748--
--
http://www.freelists.org/webpage/oracle-l