Alex Black wrote:
> hi all,
> (cc: binarycloud-dev)
>
> forgive the oracle nomanclature, but I'm used to it :)
>
> I'm trying to create a new DB, and I need to make sure that I
> have control
> over how big the files can get and how they are extended.
>
> I'm using the create test db script that comes with the
> latest version, and
> I don't see anything obvious that I can change.
There is no 'extension'mechanism (like in Oracle) known and necessary in SAP
DB.
Therefore you do not have to and you can not specify some parameters for
size/number
of extensions for a file/table/database.
There is no parameter to say : this file is not allowed to exceed more than
x KB or y pages
or something like this. As far as we heard from Oracle customers AND Oracle
- people:
usually it is hard, sometimes impossible to calculate/assume a table-size
which has
something to do with the reality in future. And as I wrote some month ago,
when I was
asked for a calculation-formula: try it, but there are so many things which
influence
the complete size of a table.
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'
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
