Home » Other » General » how does stored procedure wok between timesten and oracle database
how does stored procedure wok between timesten and oracle database [message #490733] Thu, 27 January 2011 01:57 Go to next message
okoha
Messages: 3
Registered: January 2011
Junior Member
I will use timesten in-memory database cache load data from oracle database into timesten database
In oracle database there are tableA and tableB two tables
in procedure written like below
select A.*,B.* from tableA A join tableB B on A.id = B.id
If data of tableA had been cached into timesten but tableB not cached how would the procedure above work?
would it select data of tableA from timesten and select tableB from oracle database? or both from oracle database ?

Report message to a moderator

Re: how does stored procedure wok between timesten and oracle database [message #490734 is a reply to message #490733] Thu, 27 January 2011 01:59 Go to previous message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is not the anser in the (second) document I posted you at http://www.orafaq.com/forum/mv/msg/165112/490337/102589/#msg_490337.

Regards
Michel

Report message to a moderator

Previous Topic: PERFSTATS
Next Topic: Loading data from OLTP schema to star schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 14 10:38:24 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.