error message

"Oleg" wrote:

>

>Hi All!

>

>I have problem in load of database from dumps.

>In the middle of load i am getting some error for which i donn have any

>solution..

>I am giving

>the error message below.

>

>Lock table overflow. Increase parameter -L on server

>

>

>Pls help me by suggesting what to do and how clean-up this lock table.

>

>

>Pls mail me with suggestions: olegr@iac.spb.ru

>

>Thanks in Advance

>Rgds

>oleg

The problem is because you have the -L parameter too low.

This is a startup parameter for the server and it sizes the lock table entries.

Try to increase the -L parameter or, if you didn't have it set try with a

number larger than the default (500)