Trying to create fact table and getting error:unable to extend temp segment [merged] [message #380201] |
Fri, 09 January 2009 08:37  |
sqlstar_student
Messages: 42 Registered: November 2007
|
Member |
|
|
Using Oracle 10.2g
SQL>
create materialized view facts_table
( s_id
, g_id
, sb_id
, sc_id
, y_id)
refresh with rowid
as select s.s_id
, g.g_id
, sb.sb_id
, sc.sc_id
, y.academicyear
from student s
, grade g
, subject sb
, school sc
, comqdhb.teachinggroup y;
*
ERROR at line 3:
ORA-01652: unable to extend temp segment by 1024 in tablespace POSTGRADS
I am creating the fact table as materialized view because its specified for us.
I am trying to create a fact table from the dimension tables and its giving this error
what is the mistake kindly help.
Also when creating the fact table do all the columns need to be foreign keys compulsorily.
Thank you.
[Updated on: Fri, 09 January 2009 08:39] by Moderator Report message to a moderator
|
|
|
|
|
|
Re: Trying to create fact table and getting error:unable to extend temp segment [message #380249 is a reply to message #380201] |
Fri, 09 January 2009 12:39  |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
sqlstar_student wrote on Fri, 09 January 2009 09:41 | Using Oracle 10.2g
as select s.s_id
, g.g_id
, sb.sb_id
, sc.sc_id
, y.academicyear
from student s
, grade g
, subject sb
, school sc
, comqdhb.teachinggroup y;
*
ERROR at line 3:
ORA-01652: unable to extend temp segment by 1024 in tablespace POSTGRADS
|
Not surprising based on that query. Search for Cartesian Product.
|
|
|