Re: same application on multiple schemas

From: <>
Date: Fri, 10 Apr 2009 13:40:32 +0200
Message-ID: <>

On Fri, 10 Apr 2009 02:38:48 -0700 (PDT), 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.

For what reason? What does the end-user gain by doing that
>Is this possible ? What is the best way to do that ?

Transportable tablespaces allows a tablespace to plugged in to another database. However you need a self-contained set of tablespaces, and they shouldn't be in use when transporting.

>I come from the microsoft sql server world, and here each database
>(the schema in oracle) can be detached and attached with ease.
That might be true, but then Oracle is a corporate database, and Sukkelserver is a departemental product, and will never turn into something corporate.

>I'm looking for the same in Oracle.

If you are looking to turn Oracle into Sukkelserver you are wrong. Oracle is a completely different product, it is NOT Sukkelserver sold by a different vendors.
Porting Sukkelserver databases has never worked and has made the lives of thousands of Oracle DBAs miserable, You seem to want to continue on this path.

Please get deprogrammed as soons as possible, and UNlearn everything you learned about Sukkelserver!!!!

>any help or suggestion is really appreciated!

Sybrand Bakker
Senior Oracle DBA Received on Fri Apr 10 2009 - 06:40:32 CDT

Original text of this message