Database Healthcheck Item 80: List foreign keys with non-matching column definitions, fails with "ORA-00942: table or view does not exist" (4310371)

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

戻る

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

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

評価を選択

タイトル

Database Healthcheck Item 80: List foreign keys with non-matching column definitions, fails with "ORA-00942: table or view does not exist"
説明

Since upgrading to 12.9, the Health check throws the following error when running Item 80: FK Constraints with nonmatching column definitions:
"ORA-06550: line 78, column 15: PL/SQL:
ORA-00942: table or view does not exist
ORA-06550: line 78, column 3: PL/SQL:
SQL Statement ignored"
対策

WORKAROUND
If TOAD schema exists, create the following table and synonym in the TOAD schema
CREATE TABLE CON_TEST_TBL
(
RESULT CLOB,
RESULT_NAME VARCHAR2(20 BYTE)
)
CREATE OR REPLACE PUBLIC SYNONYM CON_TEST_TBL FOR TOAD.CON_TEST_TBL;
Otherwise,
Create the table in the schema that will be running the Health Check
STATUS
Issue fixed in version 12.10. The latest release can be downloaded here.
Defect ID

TOR-1032

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

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

評価を選択

推奨コンテンツ

タイトル