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.com