ORA-01730

Error: ORA-01730: invalid number of column names specified

Causa: The number of column names specified in a CREATE VIEW statement did not correspond to the number of columns listed in the SELECT clause. If column names are specified in a CREATE VIEW statement, exactly one name must be specified for each column or expression in the SELECT clause.

Acción: Specify one view column name for each column in the SELECT clause.