Error while executing a query in sql developer.

+1 vote
asked Jun 4, 2018 by Hitesh Garg (799 points)  

I am trying to execute a query on the connected instance and getting the following error.

SEVERE 70 53918 oracle.dbtools.worksheet.sqlhistory.SqlHistoryTask oracle.dbtools.worksheet.sqlhistory.db.HistoryDB.readHistory(

I am using Oracle 12g database system.

1 Answer

+1 vote
answered Jun 4, 2018 by Rahul Singh (682 points)  
selected Jun 4, 2018 by Hitesh Garg
Best answer

This happens whenever the history files are curropted.

  1. Close your Sql Developer running instance if any.
  2. In windows go to folder C:\Users\XXXXXX\AppData\Roaming\SQL Developer\SqlHistory and rename SqlHistory folder.
    Restart your Sql Developer, errors must be gone by now.