Error Message "unable to extend temp segment by 320...)

[Guest]

I keep getting the error message "unable to extend temp segment by 320 in
tablespace TEMP (#1652) when trying to run a make table query. Anyone have
suggestions?

Thanks,
Kevin

 

[Guest]

Wait a minute - where am I? This is the Access forum isn't it? ;-)

Are you linking to an Oracle database? That error is very familer there.
Please post your SQl so we can see the problem.

You can eat up Oracle temp tablespace with Distincts, Group By, and Order By
statements. A cartisian join can also eat up the temp tablespace. Ditto UNION
queries (however a simple UNION ALL isn't usually a problem).

It's also possible that the temp tablespace is just too small or someone
else has used up most of it and you are just on the receiving end of the
problem.

 

[Tony Toews]

Wait a minute - where am I? This is the Access forum isn't it? ;-)

Are you linking to an Oracle database? That error is very familer there.

Oh good. I was wondering what alternative reality I was in. <smile>

TOny
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm