Re: Storage of data in datafiles

From: Ken-ming Wang <kenming_at_email.gcn.net.tw>
Date: 1997/11/21
Message-ID: <3475578b.31356558@news.seed.net.tw>#1/1

On Thu, 20 Nov 1997 23:41:39 -0600, ravsr_at_usa.net wrote:

>Hi
>
>I was trying to find out how the data in oracle tables are stored
>in the datafiles. Of what ever i know the rows in a table are stored in
>'blocks' in the datafile(typically they are of 2k size).
>
>1. Where is the information about these blocks of a table stored ?
>2. And can you tell me what is the format of a row header ?
>3. Is there any place in the data file where information (for example the
> address and the size of the row) about the row is stored?
>
>Your help will be greatly appreciated.
>

You had talked about the physical layer on the oracle database! For more information, you can see the "Oracle 7 Server Concepts" Actuall! these things is administrated by DBA.

Slight Heart, Thousand Miles. Ken-ming Wang ***
MCSE & CNE/CNI Certified Sys. Engineer *** FROM
LGS 3d*/Administrator On LGS Go Server ***
Welcome to LGS. http://www.lgs.hinet.net *** R.O.C

Received on Fri Nov 21 1997 - 00:00:00 CST