Temporary table - Error recovery failure (9001)
I have made temporary table like this:
CREATE TEMPORARY TABLE temp1 (towkod varchar(20), townaz varchar(40), wartnetto DECIMAL(9,2), wartzysk DECIMAL(9,2), ilotow DECIMAL(9,2)) ENGINE = InnoDB
and then insert 6 milions rows:
INSERT INTO temp1 (towkod, townaz, wartnetto, wartzysk, ilotow)
VALUES ('aaa', 'name aaa, 1.1, 2.2, 3.3)
but after insert 3 milions rows apear error:
Unrecoverable error 9001, Error recovery failure
what is wrong?
Subject
Views
Written By
Posted
Temporary table - Error recovery failure (9001)
2139
January 05, 2017 09:55AM
860
January 05, 2017 11:52AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.