Oracle Error ORA-48939: Select * not allowed in a CREATE VIEW

Oracle Error Message

ORA-48939: Select * not allowed in a CREATE VIEW

Reason for the Error

* is currently not allowed for a create view select list

Solution

List the fields explicitly