Re: same application on multiple schemas
Date: Fri, 10 Apr 2009 13:40:32 +0200
Message-ID: <1mbut4lmrbnut2i23i3vnv4snhvvoaohuc_at_4ax.com>
On Fri, 10 Apr 2009 02:38:48 -0700 (PDT), Alberto <alberto.roller_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.
>
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!
>Alberto
Sybrand Bakker
Senior Oracle DBA
Received on Fri Apr 10 2009 - 06:40:32 CDT