> If you just want to check the current size of a table, use:
> SELECT NUMERIC_VALUE from SYSDBA.TABLESTATISTICS
> WHERE owner =                           <the owner of the table you want to
> check>
>    AND tablename =                    <the tablename of the table you want
> to check>
>    AND description = 'Used  pages'

Ok, but how do I allow for growing data sets given that I need to specify
the 'size' of a devspace?

Do I just specify MAXDEVSPACES to something high like 50?

I basically did that:

I created a devspace with 100000 data pages, and set MAXDEVSPACES to 100.

Seemed to work :)

_a

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to