Batch insert discrepancies in database
Date: Tue, 10 Dec 2024 09:52:03 +0530
Message-ID: <CAEzWdqcgmr8Wropg-fH-m0kJT1i3ryfiSAwTzzcENirY7=C9KQ_at_mail.gmail.com>
Hello Listers,
I see one of the past discussions here below about the reason behind why the batch insert is not working suddenly(mainly from Oracle 12C).
https://www.freelists.org/post/oracle-l/Batch-inserts-changed-to-row-by-row,2
We are seeing a similar issue in one of our applications, but here in our case, we see batch insert is happening fine in one database(say DB1) but not getting reproduced in another database(say DB2). All the database parameters are the same in both the databases and we have Oracle 19C in both of the databases and also the driver is OJDBC-6 and the application code is exactly the same in both environments. So what else should we compare between these two environments, to understand the reason behind this discrepancies in the behaviour between these two environments?
Regards
Yudhi
--http://www.freelists.org/webpage/oracle-l Received on Tue Dec 10 2024 - 05:22:03 CET