Re: Run OLTP and DW/OLAP in the same database

From: Rotter Richard <rotter_at_aon.at>
Date: Sun, 23 Jan 2000 12:05:34 +0100
Message-ID: <388ae010$0$22452@SSP1NO17.highway.telekom.at>

Hi,

I think, that this is not possible. Because the charactaristics of an OLTP Application is different to an DW applikation. For better Tuning of the database, you have to set different init.ora-Parameters for oth of the applikation.

So, i think its not a good idea to run OLAP/DW in the same database!

Richard Rotter
Oracle DBA
email: richard_rotter_at_mediaprint.at

S S Wan <sswan_at_hongkong.com.NOSPAM> schrieb in im Newsbeitrag: 86c8aa$d9j6_at_imsp212.netvigator.com...
> Can I do thing as in the subject? It seems to save
> the effort of pouring data from one DB to another.
>
> What's the best way to run DW/OLAP? What things
> should I consider to find the most suitable products?
> Would experts here share some experience for us?
>
>
> P.S. Please remove .NOSPAM when reply by mail.
>
>
>
>
Received on Sun Jan 23 2000 - 05:05:34 CST