Sergio Samayoa wrote: > > The problem is clear (according to message): There is no space for new > tables. > Unlike other databases, SAPDB's data volumes cant grow. > Create a new data volume (use DBMCLI or DBMGUI) with enougth size to > acomodate 500 tables. > > "Jurand" <[EMAIL PROTECTED]> escribi� en el mensaje > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Sven Koehler wrote: > > >> I am writing db software that uses many kinds of > databases (MSSQL, > > >> Oracle, SYBASE etc) Before applicaion starts i need > create number of > > >> tables (200). Using SAP BD I can create only 17 at one > time (using > > >> CREAE TABLE ..). Which params can I change to increase > then nuber of > > >> created tables at one time. I'm not using transactions in table > > >> creation procedure. > > > > > > > > > What do you mean with "17 at one time" ? > > > > i run program and I have to create over 500 tables (database > > initialisation) - tables are different . After creataing 17 appears > > message : not enough space for tableids (no message number) (this is > > probably not exact mesage but I have a lot of work now - i > try it next > > time tommorrow) > > then I run next time program - after next 17 tables appears > again the > > same message. > > again and again . > > After n - times tables are created OK. > > My table is OTLP with normal (not modified) parameters. > > Creating tables in program is my libs feature. > > > > Thanx for all that are so far replays > > > > TJ
For me it is not clear, I thought 'After n - times tables are created OK' means that all 500 tables are in the database together at one time. --> the database is not too small to hold more than 17 tables at one time. As far as I understood, only the creation (not the inserts into the tables) are done in this step. --> just 17 creations would fill a database??? Noone is able to specifiy such a small amount of space to have this limit. --> please provide the message receive, perhaps a vtrace (to see what the application tries to do and may cause the problem, not the database itself). Otherwise we have to guess a little bit too much. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
