Cry about...
Oracle Troubleshooting

ORA-04043: object SSS.NNN does not exist


The following error when trying to access a table:

ORA-04043: object SSS.NNN does not exist

Where ‘SSS’ is the name of a schema and ‘NNN’ the name of a table.

Possible causes and remedies:

  • Check that the table does exist and that it is spelt correctly.
  • Check the creator/owner of the object, it may be that the table exists but is in a different schema from the current. If the table is in a different schema then try specifying the schema explicitly.
  • Check the permissions – specifically that the account experiencing the error has permissions to select the object/table in question.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.