The following is the ORA-22981 error message, you can learn the cause and solution of the Oracle database error.
ORA-22981 must specify a table/view having system generated OID
Cause: The super-view is based on a table/view having the system generated OID and the sub-view must also be based on a similar table/view.
Solution: Specify a table/view having the system generated OID and retry the operation.
Please wait for the update…