Check the v$session for the user querry. Then kill that session. Then do
oerr ORA errornumber to see the cause and action to the errornumber.

Resolve the problem, and rerun the query to confirm that it works fine.

Sam