DB Health Check returns an incorrect result for "Foreign Keys with mix of nullable and not nullable columns" (4373555)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

DB Health Check returns an incorrect result for "Foreign Keys with mix of nullable and not nullable columns"
Description

DB Health Check returns an incorrect result for "Foreign Keys with mix of nullable and not nullable columns". The report is correct for most of the findings but there are foreign keys with mix nullable and not nullable columns which are not detected properly in the report.
Cause

Defect ID - TOR-7600
Resolution

WORKAROUND:
As a workaround, please run the health check while logged in as a user who does not have privileges to run the required SQL. (Probably any user besides SYS, and not logged in as SYSDBA either).

STATUS:
Waiting for fix in a future version of Toad for Oracle.
Defect ID

TOR-7600

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title