Oracle Solution for Error ora-42301
ORA-42301: only COMPILE, READ ONLY, READ WRITE clause may be specified for an Editioning view
What triggered the Error:
ALTER VIEW statement with a clause other then COMPILE, READ ONLY, READ WRITE was issued against an Editioning view, which is the only clause supported for such views.
What should we do to fix it:
Avoid specifying clauses other than COMPILE, READ ONLY, READ WRITE when issuing ALTER VIEW statement against Editioning views.