Re: reg. problem with Temp Tablespace

From: DA Morgan <>
Date: Sat, 29 Dec 2007 11:34:43 -0800
Message-ID: <>

calms wrote:
> Hi,
> Currently im using 17gb for temp tablespace.
> Im received a error stating, "cannot allocate temp segment for temp
> tablespace".
> I increased the temp tablespace with 8gb of space. but again im
> getting the same error.
> Can somebody plz suggest, what should be done, or how to determine the
> size of temp tablespace.
> fyi, mine is oracle datawarehouse with 1.5 TB of data.
> thks

Run EXPLAIN PLAN on your query as follows: EXPLAIN PLAN SET STATEMENT_ID = 'AAA' FOR <your query here>

Then output the results as follows:
SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','AAA','ALL'));

Post the result along with your complete version number.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Dec 29 2007 - 13:34:43 CST

Original text of this message