In this chapter, we have taken a look at some of the tasks required to manage a warehouse and used Oracle Enterprise Manager to simplify management. Ongoing tasks, including backup, gathering optimizer statistics, monitoring space usage, and refreshing materialized views were discussed. Techniques for periodic reorganization using partition maintenance operations were introduced. Developing a test system and a business continuity plan are important considerations.
This has been a long chapter, but hopefully you will now begin to appreciate what is involved in managing a database. Many of the tasks described here apply equally to a traditional OLTP database. It's often the size of the data warehouse that makes the task different. Remember that it is better to manage now than not at all. Failure to back up the database or monitor space usage could have disastrous results, usually when you can least afford the time.