Need to update nearly 3cr rows in Oracle table
HI , My database is oracle 8.0 vesion.i need to update the customer_id in in table with new_customer_id. for the smaller table my simple update is working fine .. when i fired the same update for the big tables ( 30000000 rows), its running for 10 hrs and failing with rollback segments. can any one [...]

Answer Question   |  November 13, 2008  2:14 AM
Oracle 8, Oracle 8 performance, Oracle performance, Oracle Table