阅读背景:

Oracle - 故障转移表或查询操作

来源:互联网 

In a DWH environment for performance reasons I need to materialize a view into a table with approx. 100 columns and 50.000.000 records. Daily ~ 60.000 new records are inserted and ~80.000 updates on existing records are performed. By decision I am not allowed to use materialized views because the architect claims this leads to performance issues. I can't argue the case anymore, it's an irrevocable decision and I have to accept. So I would like to make a daily full load in the night e.g. truncate and insert. But if the job fails the table may not be empty but must contain the data from the last successful population. Therefore I thought about something like a failover table, that will be used instead if anything wents wrong: In a DWH environment for performance reasons I




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: