Re: same application on multiple schemas

From: <johnbhurley_at_sbcglobal.net>
Date: Fri, 10 Apr 2009 15:45:11 -0700 (PDT)
Message-ID: <ff01a2e0-0eea-4cd1-b4b5-c7f4184c1188_at_o6g2000yql.googlegroups.com>

On Apr 10, 5:38 am, Alberto <alberto.rol..._at_gmail.com> 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