My CEO wants to have two instances access one database. These are two research projects with identical table names but different project codes. The tables will be populated by the two separate projects. Reports will be generated for the projects based on the project codes. The users that populate the tables should not be able to access the data from the other project.
I have not done this before and I'm not quite sure how to start. I guess someone has done it so I need as much help as I can get please. Even if you've not really done it, I need some suggestions based on your Oracle experience.