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
Action: Specify table/view having system generated OID and retry the the operation
https://support.oracle.com/
http://www.oracle.com/