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 -> Unused datafiles

Unused datafiles

From: Frederic DEBRUS <frederic.debrus_at_ces-cdr.be>
Date: 19 Nov 1999 15:35:07 GMT
Message-ID: <01bf32a3$bdbb73e0$3e35a99e@gal159a> 





Hello there,



        I have a tablespace A composed of 6 datafiles A1 to A6
but I only use 5% of this tablespace is used so I would like to drop some
datafiles



        Is there a way other then export, drop tablespace, recreate, and import to
do it ?


also how to report which datafiles is used and which is not....



        Some guideline will be appreciated



Many thanks,


FreD
Received on Fri Nov 19 1999 - 09:35:07 CST












Original text of this message













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