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
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2006 - 13:12:04 CST