Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"zero-length columns" error on CREATE TABLE .. AS SELECT .. FROM

3199789Jul 1 2016 — edited Jul 2 2016

Hello

My db contains a view. I can select the view no problem:

SELECT * FROM MyView;


However, i am getting "zero-length columns are not allowed" error, when i try to create a table from the view:

CREATE TABLE MyTable AS SELECT * FROM MyView ;

How can i fix this?

thx

This post has been answered by 3199789 on Jul 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2016
Added on Jul 1 2016
3 comments
4,801 views