Re: error while creating a copy of a table

2008-05-24 Thread Moon's Father
Didn't you google it ? On Thu, May 8, 2008 at 1:59 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > I am getting below error. This is the only table of INNODB ENGINE, the > default storage engine is MyISAM > > mysql> create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc; > ERRO

error while creating a copy of a table

2008-05-07 Thread Ananda Kumar
Hi All, I am getting below error. This is the only table of INNODB ENGINE, the default storage engine is MyISAM mysql> create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc; ERROR 1206 (HY000): The total number of locks exceeds the lock table size how do i fix this error.