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:[EMAIL PROTECTED]
Sent: Monday, February 21, 2005 1:33 PM
To: Ajit Aranha; maxdb@lists.mysql.com
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/[EMAIL PROTECTED]
