using OLAP and OLTP together (DB 12c)
Hi Experts,
We have a requirement, where we have to use OLAP and OLTP simultaneously. Basically in a single Database. I need to come up with a design or plan for the same.
As per my understanding, we have couple of options. Like, in 12c we have In-Memory option, we can put those OLAP tables into the memory (column wise scan).
Secondly, we can prepare two separate databases for OLAP and OLTP or two separate schemas within the same DB. Does that make any sense..?
I have read one Metalink Doc (Doc ID 1590726.1), where it is written that, we can use OLAP and OLTP together in a single DB.