"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in
message news:ZVdgb.509567$cF.181415_at_rwcrnsc53...
> Perhaps you should work with databases that have been around longer.
Except
> for dbase and Foxpro, which are file based, and not RDBMS, the rest are
> relatively new. A database in Oracle is a collection of tables, views,
etc.
> In Oracle, and I think DB2, there is also a concept of owner. Which is a
> schema.
Small late comment. ISTM that a database in Oracle is a collection of files
which are talked to by one or more instances. The tables views etc are
database objects which are owned by different users. I naturally agree that
owner=schema. FWIW MSSQL might also define a database in terms of files data
and log and also has the concept of an owner.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Oct 13 2003 - 06:41:06 CDT
