December 8th, 2003, 09:21 PM
Merging 2 database on Oracle.
On the same Oracle server, I have created 2 different databases for the uses of 2 different application software. Now, I would like to merge the 2 databases into one so that each aplication can access to its own database with its tables, procedures and triggers. How to do that?
I know that one database instance can have more than 2 schema, and each schema contain its own tables, procedures, triggers, am I correct on this? If yes, how do I make that work in SQL statement?
What else should I be aware of in order to avoid conflict between tables, procedures, triggers in 2 database?
Thank for your help.