Re: Anyway to disable redo, during insert/delete ????

Joseph S. Testa wrote:
>
> there is NO way to keep redo from being generated, it is needed for
> oracle recovery
>
> joe
>
> --
> Joseph S. Testa, Oracle Database Administrator
> Vice-President Ohio Oracle Users Group, http://www.ooug.org
> Looking for an Oracle DBA on contract basis for remote DBA work? send
> mailto:teci_at_oracle-dba.com
> Need to drop a column from a table go to http://www.oracle-dba.com
> ICQ http://wwp.mirabilis.com/2832230

There is a way...but it is "use at your own risk" stuff...

The parameter _disable_logging = true will turn off logging, but whilst this is in effect you have NO recoverability...eg even if you just do shutdown abort, then your database is toast !!!

If you are just trying to speed up (say) a load into a test database then it may be useful...but don't forget to switch it off afterwards!!!!

We have used to migrate data from prod to test more efficiently, but just to reiterate...choosing to use this option must be done CAREFULLY !!!!!!!!!!!!!!

Cheers

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."