same application on multiple schemas

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
.

Relevant Pages

  • Re: Creating schema in oracle10g express edition
    ... oracle have the concept of one database, where i can create a user (and ... db2 but to create a schema i've to create a user (and i'm sorry but its ... In oracle a database has mutiple tablespaces. ...
    (comp.databases.oracle.server)
  • Re: same application on multiple schemas
    ... application must have its own "database", or schema, Oracle speaking. ...  Do they need separate schemas or do they need separate ... providing and appplication for multiple customers on a single database. ... it still scales better in Oracle. ...
    (comp.databases.oracle.server)
  • Re: Creating schema in oracle10g express edition
    ... oracle have the concept of one database, where i can create a user (and ... db2 but to create a schema i've to create a user (and i'm sorry but its ... In oracle a database has mutiple tablespaces. ...
    (comp.databases.oracle.server)
  • Re: same application on multiple schemas
    ... application must have its own "database", or schema, Oracle speaking. ... database servers. ...
    (comp.databases.oracle.server)
  • Re: same application on multiple schemas
    ... application must have its own "database", or schema, Oracle speaking. ... If you are looking to turn Oracle into Sukkelserver you are wrong. ...
    (comp.databases.oracle.server)