| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disable logging in tablespace vs using hidden parameter _disable_logging
Thanks Joseph, this is to import from oracle 9i, so datapump still is
not an alternative.
And in theory import uses datapump technology in some way I remember I
read that in some place.
On 2/2/06, Joseph Amalraj <joseph_at_amalrajinc.com> wrote:
> Hi,
>
> I do not think setting "_disable_logging" to true , will have much affect on
> the import performance, if imp has been tuned properly.
>
> Secondly if you are on 10g , datapump is an alternative.
>
> Regards
>
> Joseph Amalraj
>
>
>
> 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
>
>
>
>
>
-- 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-lReceived on Thu Feb 02 2006 - 13:13:56 CST
![]() |
![]() |