Drop Table not in Dictionary
Last updated on DECEMBER 27, 2017
Applies to:MySQL Server - Version 5.0 and later
Information in this document applies to any platform.
InnoDB tablespaces should not be moved or deleted at the OS level, but sometimes it happens. If the underlying .frm and .ibd files for a table are removed from the filesystem, the data dictionary will be out of sync with the data on disk.
This can lead to a situation in which the table can neither be dropped nor recreated.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms