Home » RDBMS Server » Server Administration » regarding deleting 80 million records (11.2.0.4)
regarding deleting 80 million records [message #634897] Tue, 17 March 2015 17:19 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Experts,
I want to delete 80 million records in database at once.
Please suggest what could I do to avoid snapshot too old error.
Can I put commits in between every 5 million records?

Thanks,

Varun
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Cannot connect to database
Next Topic: schema stats
Goto Forum:
  


Current Time: Thu Mar 28 12:33:53 CDT 2024