-
Problem updating Table with 90 million records
Hi All,
I have a table that has 90 million records and all I want to do is a simple update, add a flag to each record based on the criteria of the update statement but it keeps on crashing on me. I can't believe that Oracle 8i can't handle 90 million records so there must be something else going on. Can anyone tell me what I am doing wrong or whether there is something happening in the background that is causing the update statement to crash?
Thanks,
Edward
-
and the error is ............
-
Try using pl/sql collections with bulk collect and forall. You may want to break up the update statements into chunks based on the criteria.
-
Post the statement and the table structure (and the error, as Davey says)
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
|