AW: Table sizes -a unknown table is the largest

Ajit Aranha wrote:
> 
> Hi,
> While estimating the number of pages used by tables in SAPDB 7.3.0.48
> I get the largest table with name m and   Used  pages   112159 . This
is
> not a table created by me, and it does not appear in SQLSTudio. What
is
> his table??

MaxDB/SAP DB does not create such table either: tablename one small !
letter, never used as pre-defined tablename

Which owner is given for this table? Are you able to select that table
(if given as m you have to do a select * from "m") ?

Elke
SAP Labs Berlin

> Regards,
> Ajit
> P.S.
> I am getting table size using dataextract * from TABLESTATISTICS WHERE
> Description = 'Used  pages' and owner='XYZ'

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx