Hi Kelly,

You are using Oracle, so the answer is 'buy more disk'. If you have enough money to pay for Oracle, you have enough money to buy more disk.

Going to something like 'near line storage' for such small volumes would seem to me to just be complicating the issue.

The DW is an excellent place to put these older transactions....However, it is unlikely that they will be in a format that should be easy to just send back to the operational system to recover a transaction.....the operational system must support it's own backup/recovery reqirements separately from the DW/ODS.

If, for whatever reason, you really don't want to buy the extra disk you would need in the DW, you can always give Sybase IQ a try. It will cut your disk requirements in the DW by 75%...;-)

Best Regards

Peter Nolan

Data Warehousing Consultant

Mobile: +353 879 581 732

From: Kelly Guillory

Here is our dilema.....

We process between 1 - 3 million financial transaction per day in our OLTP.

A subset of that data is replicated into our ODS daily. We are currently purging the ODS at a rate of 120 days; however, the business users do not want to let go of their data and thought the DW would be a good place to store the additional history.

We want to stop them from using the DW as a historical data store because they don't have enough tablespace in the ODS. I was thinking of Near-Line storage as being an option. Anyone encountered this issue or has anyone used this option for data store?

This may not be the right forum but I decided to post it anyways.

Thanks in advance,

Kelly Guillory