I was wrong there:
Segments may be split between datafiles, but under the same tablespace.
--
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---
"Syltrem" <syltremzulu_at_videotron.com> a écrit dans le message de
news:8Um3b.391$G1.1588_at_tor-nn1.netcom.ca...
> 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??
>
>
Received on Thu Aug 28 2003 - 08:02:53 CDT
