Create Table from View - Oracle SQL SQL Error: ORA-01723: zero-length columns are not allowed

Viewed 23530

I need to create a table from view with statement like

CREATE  TABLE NEW_TABLE AS
    SELECT *
    from VIEW

It is giving error message as below. It is not possible to create table from view (with Select * statement)?

Error report -
SQL Error: ORA-01723: zero-length columns are not allowed
01723. 00000 -  "zero-length columns are not allowed
1 Answers
Related