Re: Disable logging in tablespace vs using hidden parameter _disable_logging
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- Date: Thu, 2 Feb 2006 15:13:56 -0400
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@xxxxxxxxxxxxxx> 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@xxxxxxxxx> 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
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
