Richard Biffl wrote > The fact sheet for SAP DB > (http://www.sapdb.org/pdf/factsheet1101.pdf) says: > "Because SAP DB dynamically regulates the growth of database > objects like > tables and indexes, disk space no longer needs to be allocated in > advance...." But it seems that disk space needs to be > allocated in advance > for devspaces. I found this out when I tried to insert a > bunch of records > and only half of them were inserted because the devspace was > full. Is there > some way to have the devspace grow, or to have the database > create a new > devspace, as the devspace fills up?
The sentence mentioned above can be misunderstood, I agree. What is meant is: you have to allocate the space for the whole database. The database software will not increase disc space by its own. The user has to decide where to store the database. But the user does NOT need to allocate disc space for every single table. Every table is allowed to grow or shrink depending on its insert/delete-commands without any necessary action by the user. If one table needs the whole space of the database, ok, if it needs only 3 pages, fine as well. Only if all tables together needs more space than was allocated to the database, the user has to add a new devspace (or delete some info). Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
