Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: temp tablespace full

Re: temp tablespace full

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Sep 2005 07:54:11 -0700
Message-ID: <1126795998.107194@yasure>


sim wrote:
> I've got a strange problem. Even after a restart of Oracle (Oracle 10g,
> 10.1.0.2.0, AIX 5.x) the temp tablespace (8 Gigs in size) remains full
> and doesn't seem to be purged. At least this is what the Enterprise
> Manager tells me.
> When I try to create a table using 'create table xxx as select ...' the
> creation always fails because the temp tablespace cannot be extended.
> I'm absolutely certain that my create statement won't consume 8 Gigs of
> temp space.
> Has anybody a clue on how to solve the problem?
> Thanks in advance.
>
> sim

  1. Read the concepts books on the TEMP tablespace. Why is this an issue?
  2. Why haven't you applied the 10.1.0.4 patch given the spare time you obviously have on your hands? ;-) -- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)
Received on Thu Sep 15 2005 - 09:54:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US