Re: How to design the database

From: daniel <test_at_test.com>
Date: Mon, 25 Mar 2002 20:10:05 -0000
Message-ID: <a7o01o$to1$1@news5.svr.pol.co.uk>

Hi,

You may want to spend a short amount of time reading the Oracle8i concepts manual... It's a great book and an often overlooked step when starting to work with Oracle.

http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a76965/toc.htm

It will walk you through users, schemas and databases. It will de-mystify it a bit for you esp if you've just come from Sqlserver.

Good luck...

--
Regards,

Daniel.


"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 - 14:10:05 CST