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 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: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