| Read consistency during partition exchange [message #63394] |
Fri, 01 October 2004 05:19 |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
We are using exchange partition in a system (Oracle 8.1.7.0.0 database) to exchange old data with new data. The new data is loaded in staging tables from multiple source systems(partitioned). When the data is cleansed and validated, the staging tables are exchanged with the target tables (non-partitioned).
The staging tables are partitioned with only one partition to be able to use the alter table exchange partition statement.
This is my question.consider the following sequence of events :-
1)User issues a long running query against the target tables.
2)Within a few seconds the alter table exchange partition command is issued and it completes.
3) The query completes .
Will data by query fetched be consistent or will old and new data be mixed bup.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
