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

Oracle Error Message

DIA-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