I’m running into an odd error when I am creating a cross connection query in DataPoint, using the Query Builder. The builder connects the tables as expected and visually seems fine, reviewed the SQL and it seems fine, but upon running the query the I am given an error box with the error : “Table ‘.\mysql\tables_priv’ is marked as crashed and should be repaired”. At this point the query will not process and closing the message just goes back to the query builder. I am not connecting to mySQL, so suspect this something within the DataPoint implementation.
Does anyone know how to repair this \MySQL\tables_priv ? and/or get past this issue?
Toad DataPoint Profssional 184.108.40.2068 (64 bit)
Connections to two different Oracle 12c databases.