Hi all,

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.