Re: Creating a large number of tables

[Jurand]

Zabach, Elke wrote:

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

Hi

My database file is 300MB - I think it is enough space
The same procedure I use (and it works) with databases like MSSQL, ORACLE, Interbase ( including sql-dialect differnces like float - number and so on)
My connection to database is via BDE->ODBC (programs are written i borland's delphi)
The message that is sent to application :
The message (exact)in Polish: sqlcreatetls(Brak miejsca do wykonania polecenia)
in English(my translation) : sqlcreatetls(Not enough space to execute command)
Probably database configuration is not good for this operations (OTLP with defaults). Server is 7.4.
Server in ver 7.3 works very similiar - but the number of tables is now about 30 (not 17) :-(

By the way - how solve problem of polish signs (like in german omlauts)-i have problem using SQL function Upper (Lower)

Tomasz Jureczko

Junisoftex Gliwice



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