Insert without redo logs or RBS??? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Insert without redo logs or RBS???

  1. #11
    Join Date
    Oct 2000
    Posts
    467
    You can try out the Copy command.
    Vinit

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    NOLOGGING will not egenrate redos for data but will always generate logging for dictionary changes, those changes you see are dictionary changes, also the new extents which are been allocated are being marked invalid as well. This is because during a recovery Oracle wont recover those extents marked invalid, invalid extents are basically extents without redo loggings.

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