4
prligence Empowering Intelligence A Real Life Case Claims Datawarehouse Several Customers/Sources Several Quarters Data Volume Was High Irregular Frequency Data Comes Often Late Near Real Time Requirements

9
prligence Empowering Intelligence Objective contd. To have an ETL Setup for Easy Addition of Objects Such As Tables, Indexes, Mat Views. Use Only Available Oracle and Unix Tools –PL/SQL –Unix Shell Scripts –SQL*Plus

36
prligence Empowering Intelligence Design … MV_* subpartitions are on the same tablespace as the parents. Subparts of MV_SUMMTAB1_0? are in the same TS as SUMMTAB1 Subparts of MV_SUMMTAB2_0? in SUMMTAB2

56
prligence Empowering Intelligence Oracle 10G Transportable Tablespaces Can Be Reinstated At a Different Operating System –Can be used for Restoring to a Different OS Tablespaces Can Be Renamed –Restoring Tablespace of the Same Name Multiple Temporary Tablespace –For Large Index Creation, Sorting, etc.