Re: TableSpace And Database

From: Randy <rmramos.gbs_at_worldnet.att.net>
Date: 1996/08/17
Message-ID: <4v3k1r$5n_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1

Structure Concept:

                     DATABASE
     TABLESPACE A               TABLESPACE B
      Datafile1 Disk1            Datafile2 Disk1
      Datafile3 Disk2
       Segment A                   Segment B
       Extent1 Extent2 ...         Extent1 Extent2 ...
       block1block2block3...       block1block2block3...

Tablespace is a logical structure - to store all financial data Datafile is a pysical structure - to store all financial data Segment is a logical structure - Account table Extent is a physical structure - space to aquire for each segment Block is a physical structure - lowest level of I/O within datafile

Hope this helps
R2
rmramos.gbs_at_worldnet.att.net
Independent Oracle Consultant Received on Sat Aug 17 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Richard Hu: "RE: TableSpace And Database"
Previous message: Mark Spiteri: "Calling DLL's from Triger"
In reply to: David Tang: "TableSpace And Database"
Next in thread: Richard Hu: "RE: TableSpace And Database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message