I'm trying to create a table from a view with fields from several tables,in the same tablespace:
create table table_name as
select * from view_name;
But I get errors everytime...Am I doing it right?
Thanks
Printable View
I'm trying to create a table from a view with fields from several tables,in the same tablespace:
create table table_name as
select * from view_name;
But I get errors everytime...Am I doing it right?
Thanks
What are the errors?
the errors are related to the tablespace storage...
Little be more detail, for example oracle error code, better with text of message.Quote:
Originally posted by jamoji
the errors are related to the tablespace storage...
Thanks,but I think I solved it.It was because there wasn't enough storage space in the tablespace.I grew up some megas,and that's all...