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: Increase tablespace size

Re: Increase tablespace size

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 26 Aug 2005 13:41:42 -0700
Message-ID: <1125088902.717912.310200@o13g2000cwo.googlegroups.com> 





It depends on a few things ...


first: what size are they currently (system 500m - 2gigs is ok by me,
and temp 4 - 16 gigs per file)


Next - what OS and what version of Oracle (size limitation...).
Also consider backup/recovery and administration of these files.  For
example, it's nice to have several files making up the TEMP tablespace,
as it allows you to shrink the tablespace without dropping the
tablespace of modifying the users.


HTH

Received on Fri Aug 26 2005 - 15:41:42 CDT












Original text of this message













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