Recently I was tasked with upgrade some MySQL instances from 5.5.16 to 5.5.32. The task seemed easy enough but when I started the process on one of the larger databases on the server (just under 1TB), it is made up of a lot smaller tables and most over 90% are 'myisam'. I ran into issues when I ran mysql_upgrade.
error : Table upgrade required. Please do "REPAIR TABLE `<name>`" or
dump/reload to fix it!
Oracle - Row duplicates in a table with a PK loaded by sql*loader
I had an interesting problem today. One of the developers told me a nightly job had stopped with an error. I check the usual things like has anything changed and was told no. The error was sent to me and was the following:
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table REPORT_TEMP
ORA-01502: index 'PK_REPORT_TEMP' or partition of such index is in unusable state
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table REPORT_TEMP
ORA-01502: index 'PK_REPORT_TEMP' or partition of such index is in unusable state
Subscribe to:
Posts (Atom)