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: tablespace deleted..............pl help me

Re: tablespace deleted..............pl help me

From: fred <anon_at_spain.es>
Date: Thu, 24 Jan 2002 11:04:20 +0000
Message-ID: <3C4FEA34.694A1EFC@spain.es> 





    
  
  1.   Connect internal via svrmgr
  
  2.   shutdown abort
  
  3.   startup mount
  
  4.   Alter database backup controlfile to trace
  
  5.   Modify trace file to remove reference to dropped data file
  
  6.   shutdown immediate
  
  7.   Delete control files
  
  8.   @modified trace file
  
  9.   Drop tablespace.






HTH



Anthony Hogan(hogananthony_at_hotmail.com)
Received on Thu Jan 24 2002 - 05:04:20 CST












Original text of this message













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