| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Tables Partitioned by Range and Updating Data
We have a database layout where we have a separate schema into which we load our data so it can be validated and manipulated before it gets moved into production. Right now these are totally separate tables in different schemas so the movement of records back and forth can be slow. If I create a table partitioned by range with the range being a flag to put the production data in one partition and the staging data in another I have the ability to keep my data in distinct areas which is an integrity issue according to the higher-ups and I also have the ability to deal with both of them as one table and still be able to use my indices. Currently I have to union the two tables together which would automatically not use the indices and is basically not usable.
My main question is that if I do this, when I change the flag (for example to move data from staging to production) will the data actually move from one partition to the other? If it does, will it be a slow transaction because Oracle will be basically inserting into the one partition and deleting from the other under the covers?
Please respond by e-mail to the below address as well as to the group.
Cheers,
Brad
 |
 |