Re: Question about merging big tables?
Posted by:
H Lee
Date: March 17, 2009 09:59AM
I just found the above error was not from the merging tables but from another SQL right after the merging:
DELETE FROM `my_final_table` WHERE `filed_1` is null;
there are 341 NULL field_1 in about 3,500,000 records and the error is:
ERROR 1206 (HY000) at line 94: The total number of locks exceeds the lock table size
Is there any fix for this issue??? many thanks,
Hao
Subject
Written By
Posted
Re: Question about merging big tables?
March 17, 2009 09:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.