Re: same application on multiple schemas

From: <>
Date: Fri, 10 Apr 2009 15:45:11 -0700 (PDT)
Message-ID: <>

On Apr 10, 5:38 am, Alberto <> wrote:
> Hello, I'm designing a new big application.
> The application will be instantiated for multiple users. Each
> application must have its own "database", or schema, Oracle speaking.
> Every schema should have separate datafiles in its own application
> folder. Databases will be on a disk array, in common with multiple
> database servers.
> I would like to be able to separate schemas so much so that, when
> needed, a schema can be detached from a database server, and attached
> to a new one.
> Is this possible ? What is the best way to do that ?
> I come from the microsoft sql server world, and here each database
> (the schema in oracle) can be detached and attached with ease.
> I'm looking for the same in Oracle.
> any help or suggestion is really appreciated!
> Alberto

I would recommend starting with the Oracle Concepts manual and Tom Kyte's 10g architecture book.

Don't make any pre-conceived ideas of how things map in oracle versus sql server. Received on Fri Apr 10 2009 - 17:45:11 CDT

Original text of this message