My "favorite" Oracle experience (not): > select count(*) from mytbl; ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

My "favorite" Oracle experience (not): > select count(*) from mytbl; ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE Well, OK then... > ALTER TABLE mytbl DROP COLUMNS CONTINUE; SQL Error: ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS.I_OBJ4 by 128 in tablespace SYSTEM The table was completely unusable, we needed to restore the DB from backup.