Re: demo db

Microsoft-speak: database
Oracle-speak: schema which refer to tablespaces

Microsoft-speak: server
Oracle-speak: instance (commonly called a "database")

So Microsoft SQL has "detachable" databases -- Oracle has "transportable tablespaces".

To create a demo database, you can run one of the scripts in /rdbms/admin. It will create tables like employees (or emp), products, etc.

:)

• Pat.

Uchakra wrote:
>
> Don't compare with sqlserver where
> you do
> use pubs or
> use master etc.
>
> Oracle consists of one database. You
> create multiple or schemas. There
> is no such thing as demo database that
> you can create.
> Regards
> Willy
Received on Fri Mar 02 2001 - 10:52:06 CST