Home » Developer & Programmer » Forms » Splitting Oracle database into two (Oracle 9i, Oracle forms 10g, Windows)
Splitting Oracle database into two [message #449094] Fri, 26 March 2010 10:47 Go to next message
Messages: 92
Registered: February 2008
Aim: Architecture change in existing application
Domain: Health Care
Background: There are 2 application ( Front end: one in oracle forms - deals with accounts module and another in some legacy application - deals with patient, clinical and diagnose module) using and sharing the same Oracle 9i database.

Patient related modules are moved into another database ( java as a front end, oracle 10g as backend ) which is normalized - eliminating duplicate tables and column, also its tables and columns names are not matching with existing (patient)system.

Now the requirement is making the existing application related only to Accounts module ( having complicated business logic written in packages ) to work as it is without changing the code, design drastically.


1. Now how best this task can be completed without affecting existing Accounts system drastically ( with minimal changes )?

2. what are the possible best approach to achieve this ?

3. what are the best way for communicating the 2 DB in this scenario ( may be creating synonym, views etc ) ?

4. What are challenges that needs to be addressed ?

Any recommendation, suggestion and solution will be very much appreciated.

Thanks and Regards

[Updated on: Fri, 26 March 2010 11:09]

Report message to a moderator

Re: Splitting Oracle database into two [message #449204 is a reply to message #449094] Sat, 27 March 2010 17:23 Go to previous message
Messages: 86
Registered: March 2010
Location: Germany
Hi lokimisc ,

i don't excatly understand all aspects of your question,
there for
i tell sth about features of ORACLE forms:

- FORMS can connect to different Databases
(in your case Oracle-Databases ( ODCD databases
is an other story)):

1.) -Create a Database-link
- create a (public) synonym for the databaselink .
- create a (public) synonym for the extern Table
- point the forms Block to this Synonym

2. Dynamic Version)
- Forms an switch the table query is based on
for example, in the PRE-Query_trigger using,
SET_Block_PROPERTY( 'BLOKXY',tablesoucre,

3. Stating a Form you can connect an other databases.
Use: on_logon-trigger
Previous Topic: Master-Detail Relationship in Oracle FORMS
Next Topic: jacob.jar not working on my server
Goto Forum:

Current Time: Fri Jul 28 06:37:57 CDT 2017

Total time taken to generate the page: 1.22877 seconds