What happens when I copy one table to another table
-
Hi ,every.
When I copy one table to another table ,what will happen when I do other DML at the same time ?
Here are A situtian I meet:
There are three table ,b1,b2,b3.And b1 is very large,b2 is empty,b3 is small.
Then I run following two transaction to copy table b1 to b2
t1:
insert into b2 select * from b1;
t2:
insert into b1 select * from b3
because b3 is small, transaction t2 will compete before t1.But After t1 complete,there is noly part of data in b3 to be inserted into b2 from b1.
what is the principle in this case?:-)
---------------------------------------
Thorn Bird... -
up~
🙂
---------------------------------------
Thorn Bird... -
Presumably the data from B3 had not been committed to B1 prior to B1 data being selected and inserted into B2.
Hope this helps,
Rich[p]
[/p]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply