Archive for April, 2009

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

April 23rd, 2009

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.