Are Oracle 'schemas' like SQL Server 'databases'?

From: Stephen <smcgerty_at_my-deja.com>
Date: Mon, 18 Oct 1999 06:55:55 GMT
Message-ID: <7ueg9p$1ol$1@nnrp1.deja.com>

Hi,

I have a fairly general question about Oracle, as I'm relatively new to the product:

What is the equivalent in Oracle of a SQL Server 'database' (ie, a group of tables, views, SPs etc. all put together, and independent of the tables and views of any other 'database')?

I'm working on a small application and I need to create a few tables, but I don't want to interfere with the tables of any other applications that are on the Oracle Server.

The documentation mentions 'schemas', but there seems to be a one to one relationship between 'users' and 'schemas'. Is it common practice to create a user of the same name as the application (eg 'PAYROLL') and then create each of the application's tables under that account (eg 'PAYROLL.EMPLOYEE', 'PAYROLL.TAXRATES')? What if one 'human' user wishes to have access to two of the applications? Do applications get written with constant references to the full table name (eg 'PAYROLL.EMPLOYEE'), or do they 'set' themselves to point to the 'PAYROLL' schema and then work from there?

I'm pretty sure I'm missing the overall picture here, so any comments would be appreciated.

Regards,
Stephen

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 18 1999 - 01:55:55 CDT