Oracle Error Message
ORA-22981: must specify a table/view having system generated OID
Reason for the Error
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 table/view having system generated OID and retry the the operation.