Home » SQL & PL/SQL » SQL & PL/SQL » Trying to create fact table and getting error:unable to extend temp segment [merged]
Trying to create fact table and getting error:unable to extend temp segment [merged] [message #380201] Fri, 09 January 2009 08:37 Go to next message
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: creating a fact table and error :Unable to increase temp segment [message #380204 is a reply to message #380201] Fri, 09 January 2009 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enlarge the tablespace.

Regards
Michel
Re: Trying to create fact table and getting error:unable to extend temp segment [message #380209 is a reply to message #380201] Fri, 09 January 2009 08:49 Go to previous messageGo to next message
sqlstar_student
Messages: 42
Registered: November 2007
Member
No privileges for making any changes.
Re: Trying to create fact table and getting error:unable to extend temp segment [message #380211 is a reply to message #380209] Fri, 09 January 2009 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to do so.

Regards
Michel
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 Go to previous message
joy_division
Messages: 4644
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.
Previous Topic: Determine Hash Size for DBMS_UTILITY.GET_HASH_VALUE
Next Topic: Retrieve Column Name
Goto Forum:
  


Current Time: Sat Dec 10 11:10:17 CST 2016

Total time taken to generate the page: 0.05550 seconds