Cause
The keyword CHECK should follow the keyword WITH in the WITH OPTION clause of the CREATE VIEW statement.
Action
Check the statement syntax and insert the keyword CHECK where required. Then retry the statement.
Oracle 26ai
ORA-00958
Error Message
missing CHECK keyword