best way to delete large number of rows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 29

Thread: best way to delete large number of rows

Threaded View

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    best way to delete large number of rows

    Hi,

    I have a table containing about 2 million rows. I need to delete about a million of them based on simple criteria, say column x = 1. But I am worry about Oracle's RBS may grow so big that it can't handle it. What is the best way to delete rows in this case? If I have to allocate a big RBS for this purpose, how do I tell it to keep before-image of the deletion in this particular RBS? Or there is a better way to achieve this?

    Thanks,
    Last edited by a128; 01-19-2003 at 07:44 PM.

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