|
Home > Archive > IQ Server > September 2005 > Using SP_IQTABLESIZE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using SP_IQTABLESIZE
|
|
| Brainyguy9999 2005-09-19, 1:26 pm |
|
I am trying to determine how much space particular tables
take up in the main DB store. The description of
SP_IQTABLESIZE seems to fit the bill but I can't seem to get
it to run. When I run it under a DBA account, I get a
correlation name OWN not found error
("SP_IQTABLESIZE(OWN.LINEUP)"). When I try to run it under
the OWN account, which is only has resource authority, it
says that OWN doesn't have the access rights to run the
SP_IQTABLESIZE procedure.
Any suggestions for finding out table sizes within the DB
would be greatly appreciated.
Thanks.
bg
| |
| Brainyguy9999 2005-09-19, 1:26 pm |
|
Nevermind. The syntax is = "CALL
SP_IQTABLESIZE('OWN.LINEUP')". I guess I need to read the
documentation a little more literally.
Thanks.
bg
> I am trying to determine how much space particular tables
> take up in the main DB store. The description of
> SP_IQTABLESIZE seems to fit the bill but I can't seem to
> get it to run. When I run it under a DBA account, I get
> a correlation name OWN not found error
> ("SP_IQTABLESIZE(OWN.LINEUP)"). When I try to run it
> under the OWN account, which is only has resource
> authority, it says that OWN doesn't have the access rights
> to run the SP_IQTABLESIZE procedure.
>
> Any suggestions for finding out table sizes within the DB
> would be greatly appreciated.
>
> Thanks.
>
> bg
|
|
|
|
|