• Does insert statement with APPEND SQL hint generate redo data?
    Post By: admin

YES, Oracle database server generates the redo data even when you insert data with APPEND SQL hint BUT Oracle database server generates minimal redo data to only record and invalidate the database blocks being impacted by the nologging operations. Needless to say that data inserted without logging is not recoverable.