Re: Disable NoLogging-Transaction

roobaron wrote:
>
> Unfortunately the answer is
>
> Don't let the users of the database do nologging type operations.
> eg not insert /*+ APPEND */, no direct loads, no alter index rebuild
> nologging.
>
> The database unfortunately is not a mind reader and so can not stop
> users with the right privileges from performing those operations.
>
> Oracle can only warn you thru the manual, that you do this and the
> standby database (thru redo logs) has the possiblility of being
> inconsistent.
>
> You will need to educate the users on what the risks are.
>
> Have Fun
>
> --
> Posted via http://dbforums.com

Or an upgrade to 9, where there is a parameter to override any attempts to use a nologging operation

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."