Re: Online alter table failure on large partitioned table
Posted by:
Rick James
Date: February 21, 2015 06:58PM
#sql-ibXXXX.ibd are the tmp tables that will be renamed when it finishes. Delete them.
Did you run out of disk space?
You seem to have a lot of secondary indexes. May we see SHOW CREATE TABLE and discuss whether some of them can be DROPped, thereby helping performance of the ALTER.
Subject
Written By
Posted
February 18, 2015 04:51AM
Re: Online alter table failure on large partitioned table
February 21, 2015 06:58PM
February 27, 2015 08:23AM
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.