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.
