Dyego, ----- Original Message ----- From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 2:33 PM Subject: Error: The table is full
> i'm running the command: > > update contratante,pessoa set > contratante.endereco = pessoa.endereco > ,contratante.cidade = pessoa.cidade > ,contratante.bairro = pessoa.bairro > ,contratante.estado = pessoa.estado > ,contratante.telefone = pessoa.telefone > ,contratante.cep = pessoa.cep where (contratante.codpes = pessoa.codpes); > > > The table contratante have 148867 rows > The table pessoa have 119319 rows > > i can update the columns endereco,cidade,bairro,estado,telefone and > cep of table contratante with the information of table pessoa... but I > start the SQL STATEMENT and the error: > > > The Table 'contratante' is full. > > > Why ? i don't insert anything inside the table contratante,only update > the columns with the pessoa information... an UPDATE generates undo log into the tablespace. We have to know how to roll back the UPDATE if it fails. That is why we have the undo log. > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento Regards, Heikki > ------------------------------------------------------------------------- > E S C R I B A I N F O R M A T I C A > ------------------------------------------------------------------------- > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- ICQ : 221602060 > $ look into "my eyes" Phone : +55 041 296-2311 r.112 > look: cannot open my eyes Fax : +55 041 296-6640 > ------------------------------------------------------------------------- > Reply: [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]