OCI-00958
missing CHECK keyword
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.