INSERT statement with nologging - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: INSERT statement with nologging

  1. #11
    Join Date
    Apr 2006
    Posts
    377
    Precisely herodt, the NOLOGGING in the SELECT as you proved is basically an alias. The table you are inserting into needs to be defined as NOLOGGING when in ARCHIVELOG mode in order to reap the benefits of reduced logging.

  2. #12
    Join Date
    Dec 2005
    Posts
    195
    David, Okay. So we can not bypass the index log for all DML that affects the index, even direct path insert. I understand now.

    Quote Originally Posted by slimdave
    Index creation and rebuild will notbe logged, but all DML that affects the index will generate index logging, even direct path insert.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width