Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> _disable_logging does not seems to work

_disable_logging does not seems to work

From: charlie cs <cs3526(no-spam)_at_yahoo.com>
Date: Fri, 11 Apr 2003 02:41:11 GMT
Message-ID: <bXpla.8451$d8.7263@nwrdny02.gnilink.net>


We are using 9.2.020 on windows 2000.
We have a database for testing purpose. Every time we recreate the new database and then importing the data from production to ensure identical environment for testing purpose.

I set _disable_logging=true to speed up the import. But oracle still using the online redo logs, when I search against the v$log, I can still see the status of log member changing from inactive=>current=>active.

How can I completely turn off the redo logging? Unable to recove is not our concern here. We just want a fast import.

Thanks for your help. Received on Thu Apr 10 2003 - 21:41:11 CDT

Original text of this message

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