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: Fri, 3 Feb 2006 00:15:00 +0100
Message-ID: <6e9345580602021515s133c74fm199fcd29ccb0955e@mail.gmail.com>


I am not sure where did you get the idea of import uses datapump technology.... which is totally false.

Import is an old technology, Datapump a new one, an old technology cant use a new technology because it simply doesnt know about it!

On 2/2/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2006 - 17:15:00 CST

Original text of this message

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