Re: 10g - Configuration Issues to support multiple apps.

Lee Chalupa via OracleMonster.com wrote:
> 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

First please clarify your meaning when you use the term database. Do you mean "database" as in SQL Server or Informix or do you mean database as in Oracle. I, like Sybrand, don't see a need for more than one database ... but that database containing multiple schemas.

With respect to tracking changes you could use a DDL trigger to track them if you wanted but as Sybrand has indicated it really is unnecessary.

When you are ready to extract the DDL to recreate the schema you can use the DBMS_METADATA built-in package. It is documented at http://tahiti.oracle.com and there is an example of doing this with DBMS_METADATA.GET_DDL at http://www.psoug.org. Just click on Morgan's Library then click on DBMS_METADATA.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)