When setting the table to NOLOGGING, what is the expected result?
The actual result would depend if database is in ARCHIVE MODE or not, and if the INSERT on table is in APPEND mode or not.
Table Mode Insert Mode ArchiveLog mode Result
----------- ------------- ----------------- --------------
LOGGING APPEND ARCHIVE LOG redo generated NOLOGGING APPEND ARCHIVE LOG no redo
LOGGING NO APPEND ARCHIVE LOG redo generated
NOLOGGING NO APPEND ARCHIVE LOG redo generated
LOGGING APPEND NOARCHIVE LOG MODE no redo
NOLOGGING APPEND NOARCHIVE LOG MODE no redo
LOGGING NO APPEND NOARCHIVE LOG MODE redo generated
NOLOGGING NO APPEND NOARCHIVE LOG MODE redo generated
No comments:
Post a Comment