Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
RE: Table sizes -a unknown table is the largest
From: Ajit Aranha (ajitonmobile.com)
Date: Tue Feb 22 2005 - 04:43:07 CST
SQLStudio version is 22.214.171.124
Select * from tables where tablename='m' returns:
OWNER TABLENAME PRIVILEGES TYPE TABLETYPE
CREATEDATE CREATETIME UPDSTATDATE UPDSTATTIME
ALTERDATE ALTERTIME UNLOADED SAMPLE_PERCENT
SAMPLE_ROWS COMMENT TABLEID
ONMOBILE m SEL+UPD+DEL+INS+REF+IND+ALT+ TABLE TABLE
2003-08-19 21:32:15 2003-08-19 21:32:15
2004-07-14 13:31:11 NO ?
20000 ? 00000000000002C0
I noticed that the tablename m is in lowercase,while other tablenames
are in uppercase in the "table" view
Also select * from onmobile.m does not work. (says unknown tablename m.
Yes I am connected as the user ONMOBILE)
Select * from m works however.
From: Auer, Wolfgang [mailto:wolfgang.auersap.com]
Sent: Tuesday, February 22, 2005 3:38 PM
Subject: RE: Table sizes -a unknown table is the largest
Which version of SQL Studio do you use?
Can you see the table m when you do "select * from tables"
Von: Zabach, Elke
Gesendet: Dienstag, 22. Februar 2005 09:50
An: 'Ajit Aranha'
Betreff: AW: Table sizes -a unknown table is the largest
Ajit Aranha wrote:
> Hi Elke,
> FYI the table "calldetailrecord" is one of mine. I don't know
> why/how it got renamed to "m". What is strange is the table "m" does
> appear in SQLStudio's list of tables.
> Can you tell me in what case a table does not appear in the
> SQLStudio's list of tables even when it exists for the connected
Hope, this will be answered by a SQLStudio-guy.
> Also is it possible to rename a table via SQL queries or from
As you can see in the reference manual:
Data-definition--> rename table
SAP Labs Berlin
> Thanks and Regards,
> -----Original Message-----
> From: Zabach, Elke [mailto:elke.zabachsap.com]
> Sent: Tuesday, February 22, 2005 1:53 PM
> To: Ajit Aranha
> Cc: maxdblists.mysql.com
> Subject: AW: Table sizes -a unknown table is the largest
> 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
> > "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
> existed so far.
> 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 *
> > "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.zabachsap.com]
> > Sent: Monday, February 21, 2005 1:33 PM
> > To: Ajit Aranha; maxdblists.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
> > > I get the largest table with name m and Used pages 112159 .
> > is
> > > not a table created by me, and it does not appear in SQLSTudio.
> > 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
> > (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
> > > Description = 'Used pages' and owner='XYZ'
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb