Hi Wolfgang,
SQLStudio version is 7.4.3.3
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.
Regards,
Ajit
-----Original Message-----
From: Auer, Wolfgang [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 3:38 PM
To: [EMAIL PROTECTED]
Subject: RE: Table sizes -a unknown table is the largest
Hello Ajit,
Which version of SQL Studio do you use?
Can you see the table m when you do "select * from tables"
Regards
Wolfgang
-----Urspr�ngliche Nachricht-----
Von: Zabach, Elke
Gesendet: Dienstag, 22. Februar 2005 09:50
An: 'Ajit Aranha'
Cc: [email protected]
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
not
> 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
user??
Hope, this will be answered by a SQLStudio-guy.
> Also is it possible to rename a table via SQL queries or from
> SQLstudio??
As you can see in the reference manual:
Data-definition--> rename table
http://dev.mysql.com/doc/maxdb/en/6d/117c1dd14811d2a97400a0c9449261/fram
eset.htm
Elke
SAP Labs Berlin
> Thanks and Regards,
> Ajit
>
> -----Original Message-----
> From: Zabach, Elke [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 22, 2005 1:53 PM
> To: Ajit Aranha
> Cc: [email protected]
> 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
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]
