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: Datafiles

Re: Datafiles

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/08/02
Message-ID: <15180b6d.6a380224@usw-ex0104-031.remarq.com>#1/1 






I don't know of an easier way than the following.



    
  
  1.   Shutdown database and take a cold backup.
  
  2.   Restore previous database from backup.
  
  3.   Export table (start taking nightly exports to avoid this in
the future)
  
  4.   Shutdown database and restore data from cold backup
  
  5.   Truncate table or drop it and restore from export you just
took.






-Ethan



http://www.gnumetrics.com







Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!


http://www.keen.com
Received on Wed Aug 02 2000 - 00:00:00 CDT












Original text of this message













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