Re: database, tablespace, user confusion

Database:
Bunch of tablespaces + all other components (control files, redo logs, etc) required to manage them and the segments therein.

Database:
A number of tablespaces that comprise a number of datafiles that comprise a number of segments (one per object - table, index, or else) that comprise a number of extents that comprise a number of Oracle data blocks that comprise a number of OS blocks on disk.

A look at the documentation is what you need for a more detailed explanation on how these components are related to one another: http://tahiti.oracle.com

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"DukeNM" <tridentadm_at_netscape.net> a écrit dans le message de
news:6b07a80.0308280407.24c45407_at_posting.google.com...


> i am newbie to oracle dba. (and even oracle i guess)

>

> but anyways comming to the point...

> i am getting a little bit confused on

> create user

> create tablespace

> create database

>

> if a tablespace is logical specification of physical datafiles

>

> what does database do??