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 -> Question about resizing a tablespace

Question about resizing a tablespace

From: W. Scott Moore <sirws_at_hotmail.com>
Date: 2000/05/01
Message-ID: <BWnP4.121$g53.8580@news.uswest.net>#1/1 






What are the ramifications of increasing the size of a datafile?



for example, my 'users' tablespace/datafile is 25M and I want to increase it
to 100M



alter database gpro


datafile 'e:\oracle\gpro\users.ora'


resize 100M



Does this cause fragmentation and other issues that can affect performance?



Any info/insight would be greatly appreciated.



Thanks,


Scott
Received on Mon May 01 2000 - 00:00:00 CDT












Original text of this message













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