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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to delete datafiles

Re: How to delete datafiles

From: Frenchy461 <frenchy461_at_aol.com>
Date: 5 Oct 1998 16:06:26 GMT
Message-ID: <19981005120626.12300.00002434@ng136.aol.com> 






    
  
  1.   You should probably shutdown the instance. bring it back up into restricted
mode.
  
  2.   Turn Rollback segments offline.
  
  3.   Drop tablespace which these datafiles belong to(make sure to know which
datafiles are to be kept for re-creation).
  
  4.   Go to operating system, and delete all files of this rollback segment
tablespace.
  
  5.   Re-create this tablespace with needed files(if this tablespace is needed.)




Received on Mon Oct 05 1998 - 11:06:26 CDT












Original text of this message













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