How can delete an orphaned temporary table on Mysql Innodb?
Go into the filesystem (DOS prompt, shell prompt, whatever) and delete (rm, whatever) any files starting with #sql

Also check to see how much free space exists on disk.  ALTER usually copies the entire table over.