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

Home -> Community -> Usenet -> c.d.o.server -> Re: Temp Tablespace very large oracle 9ir2

Re: Temp Tablespace very large oracle 9ir2

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 29 Nov 2005 21:41:07 +0100
Message-ID: <dmidq9$ooc$4@news4.zwoll1.ov.home.nl> 





aj70000_at_hotmail.com wrote:


> Hi,

> 

> Our temp tablespace has grown very large (62 GB). Is there a way to

> control the size? it is a huge runoff.

> 

> Thanks 

> AJ

> 



Of course...


It's in the manual: MAXSIZE parameter of the create
tablespace command (datafile section)


-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...


Received on Tue Nov 29 2005 - 14:41:07 CST












Original text of this message













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