| Read consistency during partition exchange [message #63382] |
Thu, 30 September 2004 05:18 |
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 first loaded into 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.( The target tables are expected to be continously available for user queries).
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
