DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 13

Thread: Please suggest a better way

Threaded View

  1. 02-07-2006, 06:16 PM #12
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    There will be new rows getting created in the source table though.
    So NOLOGGING might not be a good idea.

    Since other activity is taking place at the same time, Tamil's solution has the advantage of keeping the database always in a consistant state - you'll never find a row in two places.
    Last edited by DaPi; 02-07-2006 at 06:20 PM.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width