RE: Datafile vs Tablespace

From: Javier Morales <javier_at_infojobs.net>
Date: Fri, 20 Oct 2000 10:42:04 +0200
Message-ID: <8sp0i1$qe$1@diana.bcn.ttd.net>

I hope this basical 'physical-logical' map of Oracle would help you (please, don't laugh about my "ascii art" eheeh...)

                  logical                        physical
                  ------                        ---------

             Database
                  \|/
                   |
             Tablespace     -----?     Datafiles
                  \|/                              /    |
                   |                           /        |
             Segment                 /            |
                  \|/                  /                |
                   |               /                    |
             Extension   /|\                       |
                  \|/                                   |
                   |                                   /|\
           Oracle Block  ------?      OS Block

I hope this would help you... so, then... a tablespace may contain several segments (rollback ones, tables, indexes, clusters, etc.) but they can be allowed more than one datafile (imagine the usage of a rollback segment, It's for managing transactions that maybe use much extensions, and they can be created in another datafile)...

... hmm... I think It's enough clear... let me know if you understand it... ;-)

Chang Houw <exortica_at_bigfoot.com> escribió en el mensaje de noticias nR2I5.9410$K6.63549_at_news...
> Hello there i'm new on Oracle, what's the different between datafile and
> tablespace ? :P
>
>
Received on Fri Oct 20 2000 - 03:42:04 CDT