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 -> recovering data

recovering data

From: Antonio Da Silva <news_at_nioto.com.NoSpamMerci>
Date: Thu, 16 Jan 2003 23:23:56 +0100
Message-ID: <b07be0$b8s$1@news-reader10.wanadoo.fr>


Hi,

I just remove all content from a table in an Oracle 9i server,

after many tries to restore it with the redologs, I can get it back,

I use :
--

sql> connect internal
sql> shutdown
sql> startup mount
sql> recover database until ='16-JAN-2003:00:00:00'
sql> alter database resetlogs

---

No error are displayed, and
oracle says that recovery is done, but my table is always empty, did I miss something ?

Thanks

Tonio Received on Thu Jan 16 2003 - 16:23:56 CST

Original text of this message

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