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

Home -> Community -> Mailing Lists -> Oracle-L -> How to resize the data files

How to resize the data files

From: <oracle-l-bounce_at_freelists.org>
Date: Wed, 18 Apr 2007 17:36:47 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51804E028B6@ex2003.metratech.com> 





Hi,



We had a 4 big table in tablespace ts1 and we range partition the tables
into 4 partitions and assigned tablespaces ts2-ts5 and now we want to
reduce the size of the datafiles in ts1. Even though the data for the
big tables does not exists on ts1 anymore but due to high water mark it
is now allowing me to shrink the datafiles.



What is the best possible way to resize the files. 



Thanks


--Harvinder




--



http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 16:36:47 CDT












Original text of this message













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