reg. problem with Temp Tablespace

From: calms <>
Date: Fri, 28 Dec 2007 23:13:30 -0800 (PST)
Message-ID: <>


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 Received on Sat Dec 29 2007 - 01:13:30 CST

Original text of this message