SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete 84000 rows from a table in a single stretch

418679May 2 2004 — edited May 3 2004

Hi friends

Could you please tell me How do I delete 765,000 rows from a table in a single stretch.

If I use truncate table it will flush out all records
but I want to delete records till 31-dec-03, in this case I cant use truncate command.. using delete it gets hanged and finally rollback error.

Thanks
Sai

Locked Post

New comments cannot be posted to this locked post.

Locked on May 31 2004

Added on May 2 2004

11 comments

3,490 views