Commmit in ORA
Posted: Thu Mar 17, 2005 11:27 am
FOLKs,
I have problem in identifying the commit command in ORA, I have million records comming in I want to commit after every 50,000 records, I was of the opinion rows per transaction under transaction handler is one which takecare of this, I had selected readcommit option but I want commit after every 50,000 records, SQL is user defined, could some one help on this
thanks
ranga
I have problem in identifying the commit command in ORA, I have million records comming in I want to commit after every 50,000 records, I was of the opinion rows per transaction under transaction handler is one which takecare of this, I had selected readcommit option but I want commit after every 50,000 records, SQL is user defined, could some one help on this
thanks
ranga