Re: table size in bytes

Murray Kaiser (ae873_at_cfn.cs.dal.ca) wrote:
> : where NNN is the absolute block address of the header block of the
> : table you are interested in. This generates a symbolic block dump
> : of the table header. With a little guess work you can figure out
> : what it all means.
> How do you get the block address of the header block of the table I am
> interested in??

from dba_segments. There is a header_file and header_block column Use power(2,26)*headerfile + headerblock

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************