Re: Standby database as reporting server

See Mark Rittman's blog http://www.rittman.net/index.html and realize that the Oracle you already have has a lot more than the SQL Server you don't. Also, consider Oracle XE as a place to suck your OLAP to - if some marketing guy wants to load up his processor, do it on his machine. Also streams, materialized views, plain old CTAS statements (and more) can help distribute the load away from the transactional processor. But don't write off just buying a bigger processor and keeping things centralized, either. Oracle's older, stable standby technology can be very useful if you only need up-to-last-night reporting.

Here's more info:
http://www.oracle.com/solutions/business_intelligence/index.html

jg

--
@home.com is bogus.
I wanna be an expert in foreign currency trading too!
http://www.signonsandiego.com/uniontrib/20051217/news_1b17whitepin.html