Nologging inserts generates no redo: WRONG!!!!!!!!!

In most case NOLOGGING generetaes no redo; true. But by adding a foreign key constraint to the table it disables direct mode inserts and resorts to conventional mode logging.

The direct load is also disabled for index organized table.

Leave a reply

You must be logged in to post a comment.