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: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Thu, 2 Feb 2006 15:13:56 -0400
Message-ID: <cd4305c10602021113h68e4b233pad5586f22342ce07@mail.gmail.com>


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-l
Received on Thu Feb 02 2006 - 13:13:56 CST

Original text of this message

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