Re: How to design the database

From: Epicentre Team A ANNECY <djeanneret_at_epicentre.fr>
Date: Mon, 25 Mar 2002 11:17:17 +0100
Message-ID: <a7mt4p$2s1$1@wanadoo.fr>

Hello

You can use only one instance and manage 3 differents schemas. Schema NAME1 for your first database in the ORCL instance Schema NAME2 for your first database in the ORCL instance Etc ...

Denis

"Rudy Susanto" <rsusanto_at_atlas-sp.com> wrote in message news:1a928d0b.0203242220.46c4ce1c_at_posting.google.com...
> Hi all,
>
> I just have a little problem about database design with oracle
> database.
>
> I have 3 databases on sqlserver such as gldt(general ledger),
> fadt(fixed assets), and leasedt (leasing). I want to create database
> on oracle but i don't know what i sould do because the oracle and the
> sqlserver is not the same.
>
> Maybe i just have 2 choices, create 3 databases just like on sqlserver
> or just create only one database. If i create just one database, maybe
> too difficult to me to maintain the database. When i create 3
> databases, i will have 3 instances that will degrade the performance.
>
> I don't know which is better, i need some suggestions.
>
> Thank in advance,
> Rudy Susanto
Received on Mon Mar 25 2002 - 04:17:17 CST