10g - Configuration Issues to support multiple apps.

I'm a java developer that is learning to work with oracle 10g.

I've installed 10g and I've read the installation guide and the DBA -two day guide.

I'm trying to setup an instance of Oracle to use to prototype a couple of small applications.

One application/database server will support the database needs of these applications each supporting a small number of users and small volumes.

Each application will eventually have a production database and a test database. The applications may or may not share common data with each other.

I'd like to be able to track the tables and other database objects used by each application in case I have to move the applications in the future.

How do I configure oracle to to support these requirements?

For example, one instance or more? One database or more? Does the use of a schema come into play here?

I'd like to use EM to administer the configuration but I don't want to mess with implementing the grid control.

Any references to further documentation would be helpful as well.

Thanks.

lee

-- 
Message posted via http://www.oraclemonster.com