I created a table under my Oracle user from Alteryx, a third-party application. In SQL Developer I can see the table under my user's schema and I can see all the data and properties. However I cannot query it even when specifying the user (error: ORA-00942: table or view does not exist).
The following query correctly returned my user name:
select owner,
object_name
from dba_objects
where object_name = any ('test_spread');