| 10.2..0..2 [message #352797] |
Thu, 09 October 2008 11:22  |
varunvir
Messages: 389
Registered: November 2007
|
Senior Member |
|
|
Hi Experts,
I have to insert 50000 records in production database.
I generated statements with commit after every 1000 inserts.
Is it good idea ??
Regards,
Varun Punj
|
|
|
|
| Re: 10.2..0..2 [message #352798 is a reply to message #352797] |
Thu, 09 October 2008 11:25  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Big, Bad and Ugly.  . That is generic.
I mean, your server may not go down on its knees.
Generally, it is just a bad idea. Depending on your environment, you may
run into other issues.
Meanwhile, 50,000 records is minuscule.
[Updated on: Thu, 09 October 2008 11:32] Report message to a moderator |
|
|
|
|
|
| Re: 10.2..0..2 [message #352801 is a reply to message #352800] |
Thu, 09 October 2008 12:01 |
varunvir
Messages: 389
Registered: November 2007
|
Senior Member |
|
|
sorry about that Michel...
Mahesh thanks for your advice.I am going to remove all
the commits now.
Regards,
Varun Punj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
