Re: Difference between 'Database' and 'Tablespace'?

From: Arati Vijay <vijayj_at_singnet.com.sg>
Date: Mon, 18 Oct 1999 23:51:39 +0800
Message-ID: <7uffta$5vo$1@mawar.singnet.com.sg>

A database is a repository of data. An Oracle is defined similarly. It can consist of multiple tablespaces depending on the configuration.

A database is divided into tablespaces. Each tablespace consists of datafiles. Each datafile consists of segments, which are made up of blocks.

Hope this answers your query.

Regards,
VJ

Jack <zhangjun1975_at_263.net> wrote in message news:01bf1921$126223e0$b20a0a0a_at_smile.newksy.com.cn...
> Hi all:
>
> I'm new to Oracle, I don't know the difference between 'Database' and
> 'Tablespace'. Please tell me the answer ?
>
Received on Mon Oct 18 1999 - 10:51:39 CDT