'Objects referenced in this sql may not be available to the current user' (4244195)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

'Objects referenced in this sql may not be available to the current user'
Description

Toad
User uses 'Explain Plan' in the Kill/trace option and gets a message 'Objects referenced in this sql may not be available to the current user' . Looking at the sql monitor for Toad back ground sql, an Oracle error occurred: 942 (ORA-00942: table or view does not exist).
Resolution

Use the Toad Sql Monitor to see which table has not been correctly prefixed with the correct schema name and prefix the table_name with schema-owner .

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title