Re: Very basic question
Date: Sat, 03 Sep 2005 18:41:40 GMT
Message-Id: <pan.2005.09.03.18.45.59.489752_at_telus.net>
On Sat, 03 Sep 2005 12:21:38 -0400, FC interested us by writing:
Think of it this way ...
A schema is roughly the same as a SQL Server database; A database in Oracle is the complete set of disk files; An instance is the memory and CPU cycles needed to get at the database.
Your 'master database' is roughly the Oracle SYS schema.
PLEASE consider getting a copy of O'Reilly publishing's "Oracle Essentials" (see http://www.oreilly.com/catalog/oressentials3/) as it will help you get over the language hurdle. Then you can read the "Oracle Database Concepts" manual and the "Application Developer's Guide - Fundementals" or "Administrator's Guide" to get the details appropriate to your job.
If developing, realize that the internals of Oracle are sufficiently different from SQL Server that an application written for one will rarely work well for the other - decent explanation about why and how you need to approach Oralce development in Tom Kyte's "Effective Oracle by Design"
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** I no longer assist with top-posted newsgroup queries ***Received on Sat Sep 03 2005 - 20:41:40 CEST