Re: A transactionally consistent view on real-time data with MicroStrategy

On 2 Jun 2006 14:36:55 -0700, erik.ykema_at_gmail.com wrote:

>So I feel like not being able to solve this elegantly, and perhaps
>needing to file enhancement requests with both Oracle (serializable
>session) and MSTR (AS OF option and/or CTAS to be changed in Create All
>Tables First and Later Insert Into Them.)
>
>Any comments and or suggestions are highly appreciated.

I would suggest a third option.
It is generically called 'lawyers'

Obviously MSTR is some 'database independent' crap, developed under SQL server and 'ported' to Oracle, whereas a complete rewrite would have been better.
Assuming you are a small customer, the powers at Oracle would not consider your 'enhancement request', which will incidentally break the complete architecture, favorable.

--
Sybrand Bakker, Senior Oracle DBA