Re: [GENERAL] WARNING: out of shared memory

2010-04-21 Thread akp geek
That's what I did. I did it for every 500 tables . 4 chunks.. It worked Regards On Wed, Apr 21, 2010 at 12:30 PM, John R Pierce wrote: > akp geek wrote: > >> Hi All - >> >>I have been trying to drop 2000 tables using a script. I am >> getting the following error message. I have

Re: [GENERAL] WARNING: out of shared memory

2010-04-21 Thread John R Pierce
akp geek wrote: Hi All - I have been trying to drop 2000 tables using a script. I am getting the following error message. I have the value set for max_locks_per_transaction = 100 . Error message is as follows WARNING: out of shared memory ERROR: out of shared memory HINT:

[GENERAL] WARNING: out of shared memory

2010-04-21 Thread akp geek
Hi All - I have been trying to drop 2000 tables using a script. I am getting the following error message. I have the value set for max_locks_per_transaction = 100 . Error message is as follows WARNING: out of shared memory ERROR: out of shared memory HINT: You might need to inc