RE: Table sizes -a unknown table is the largest

Hi Elke,
        Yes I am able to select from it despite it not appearing in
sqlstudio.
I have determined that the table "m" contains data from a table called
"calldetailrecord" which seems to have gone missing in sqlstudio (I
can't even query from it).
 Is it possible that somehow as part of a drop table/delete all rows
operation in sqlstudio the table got renamed?
Also why would this table "m" not appear in SQLStudio but select * from
"m" still work?
        Luckily this table contains non crucial data and I can delete
it. Any clues on the likely cause of this table "calldetailrecord"
having being renamed and not appearing in SQLstudio will be much
appreciated.
Regards,
Ajit

-----Original Message-----
From: Zabach, Elke [mailto:elke.zabach@xxxxxxx] 
Sent: Monday, February 21, 2005 1:33 PM
To: Ajit Aranha; maxdb@xxxxxxxxxxxxxxx
Subject: 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