Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to design the database
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...Received on Mon Mar 25 2002 - 14:10:05 CST
> 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