Concurrent Transactions and Unique ID
Hello,
Due to a large number of data that should be written to a table, we want to split it into manageable blocks. Primary key is taken from a sequence. This key is also a foreign key in child tables and shoud be known for further processing. Each transaction read the current sequnce next value and update it to the required block size (lets say to 500). As one cannot lock the sequence during reading its next and update value there is a chance that parallel transactions are using or reserving the same set of Ids. How to get tranaction wide
Due to a large number of data that should be written to a table, we want to split it into manageable blocks. Primary key is taken from a sequence. This key is also a foreign key in child tables and shoud be known for further processing. Each transaction read the current sequnce next value and update it to the required block size (lets say to 500). As one cannot lock the sequence during reading its next and update value there is a chance that parallel transactions are using or reserving the same set of Ids. How to get tranaction wide
0