Re: demo db

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 5 Mar 2001 15:08:52 -0000
Message-ID: <980a68$l57$1@soap.pipex.net>

A schema does NOT refer to a tablespace.

A schema is a collection of database objects, if anything it relates to a user account. so for example the Scott schema consists of the demo tables,indexes etc that come with oracle. It is a logical collection of database objects

A tablespace is a collection of one or more datafiles and is a set of physical storage areas for database objects.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Pat Boivin" <lori.pat_at_ns.sympatico.ca> wrote in message
news:3A9FCF36.715E93D8_at_ns.sympatico.ca...


> 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 Mon Mar 05 2001 - 09:08:52 CST