Error "The parser did not identify the text as a valid SQL statement" along with ORA-00942 (4305861)

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

Error "The parser did not identify the text as a valid SQL statement" along with ORA-00942
説明

The following error occurs when sending a query for optimization from Spotlight on Oracle:
"The parser did not identify the text as a valid SQL statement"
and then "ORA-00942: table or view does not exist" at the bottom.
原因

The connection was made as Spotlight user. If the objects are not fully qualified with the schema name or the Spotlight user does not have permissions to access the objects, then "ORA-00942" will be returned.
対策

Select the relevant schema from the dropdown:

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

タイトル