create table from view
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: create table from view

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    What are the errors?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    the errors are related to the tablespace storage...

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by jamoji
    the errors are related to the tablespace storage...
    Little be more detail, for example oracle error code, better with text of message.

  5. #5
    Join Date
    Jan 2002
    Posts
    152
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width