Ajit Aranha wrote: > > 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).
Noone within MaxDB-development knows this table calldetailrecord. Therefore we cannot help. During dropping / deleting a/from a table, that table is not renamed, neither to "m", nor to another name. Sorry, but we will not be able to help finding out why this funny table existed so far. Elke SAP Labs Berlin > 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; [email protected] > 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]
