reg. problem with Temp Tablespace
From: calms <calmsqurill_at_gmail.com>
Date: Fri, 28 Dec 2007 23:13:30 -0800 (PST)
Message-ID: <2fe1a16e-d9d8-48d4-aa36-a7929e9575a1@e23g2000prf.googlegroups.com>
Date: Fri, 28 Dec 2007 23:13:30 -0800 (PST)
Message-ID: <2fe1a16e-d9d8-48d4-aa36-a7929e9575a1@e23g2000prf.googlegroups.com>
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 Received on Sat Dec 29 2007 - 01:13:30 CST