Re: Creating a large number of tables

[Jurand]

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






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