Why not just backup your prod database (which you should already be doing)
and restore it in test. No import required.
Jim
"charlie cs" <cs3526(no-spam)@yahoo.com> wrote in message
news:bXpla.8451$d8.7263_at_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 - 22:10:49 CDT
