Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disable NoLogging-Transaction
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.comReceived on Thu Sep 19 2002 - 22:37:21 CDT