| Compatibility between TimesTen and Oracle databases [message #463279] |
Wed, 30 June 2010 08:56  |
fran_indra
Messages: 3
Registered: June 2010
|
Junior Member |
|
|
Hi there,
I'm not sure if this is the right side for my question, I apologize if not.
I have an Oracle 11g db and I'm considering installing the Oracle TimesTen In-Memory Database Cache (v11.2) to increase the general performance but, after reading the Oracle documentation and the information I found in internet I have some doubts that maybe you can clarify for me:
• What happens with all the PL/SQL procedures, triggers and packages stored in the DB and with the OS scripts? I mean, Will they continue working without any change from my side or I need to do changes?
This question comes because I have read that exist problems of compatibility between TimesTen and Oracle like problems with Roles, Profiles, Tablespaces, Rollback Segments, etc, besides having differences between some data types.
• What happens with the JAVA and C applications that connect to the db which I have already developed and working? I mean, Will they continue being able to send the same SQL statements to the DB?
From what I have seen so far, it seems the only thing I have to do is to change the local ODBC client driver to point to the TimesTen db server and after that, by means of the Passthrough Feature, every SQL statement incoming will be executed on the TimesTen db if possible and redirected to the Oracle db in other case. Is that correct or I have to change the apps code?
• Is it possible to use TOAD to connect and configure the TimesTen db or I have to use SQL Developer? I see that I need to perform some configuration steps on SQL Developer before being able to use it with TimesTen db.
• Is there any other problem about compatibilities that I'm missing and I should take in consideration?
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Compatibility between TimesTen and Oracle databases [message #464558 is a reply to message #463279] |
Thu, 08 July 2010 07:11  |
fran_indra
Messages: 3
Registered: June 2010
|
Junior Member |
|
|
It seems that to get advantage of TimesTen you have to design the architecture thinking from the beginning in this utility and redesign an existing architecture to retrofitting TimesTen will be difficult and require quite changes in the applications source code and PLs. That's because of TimesTen does not support triggers, XML, user data types, etc and its SQL is not 100% compatible with Oracle SQL.
[Updated on: Thu, 08 July 2010 07:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
