Cry about...
Oracle Troubleshooting

ORA-04043: object SSS.NNN does not exist

Symptom:

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.