Sender: tcross@tiger.rapttech.com.au Newsgroups: comp.databases.oracle.server Subject: Re: How to recover a dropped table ? References: <73q7gvsqbfeb4amjb6pt8304kc65h5npdt@4ax.com> From: Tim X Reply-To: timx@spamto.devnul.com Date: 07 Jul 2003 18:42:35 +1000 Message-ID: <87of06budg.fsf@tiger.rapttech.com.au> Lines: 22 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii NNTP-Posting-Host: ppp597.nsw.padsl.internode.on.net X-Trace: duster.adelaide.on.net 1057566502 ppp597.nsw.padsl.internode.on.net (7 Jul 2003 17:58:22 +0950) Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.superfeed.net!propagator2-maxim!news-in-maxim.spamkiller.net!snewsf0.syd.ops.aspac.uu.net!news1.optus.net.au!optus!news.mel.connect.com.au!news.ade.connect.com.au!duster.adelaide.on.net!not-for-mail Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237043 >>>>> "MJ" == MJ Wood writes: MJ> Hi, It happened a few day ago that one of our developer MJ> "accidentally" dropped a table in our development database(no MJ> archive log). The data in this table (about 100 lines) is not MJ> very important so the data was re-created manually. Anyway, I MJ> just wondering how can I recover the data in the dropped table. MJ> This table was dropped around 4pm and at 6pm this database was MJ> idle. I think the data was still in the redo log. How can I MJ> rollback the tablespace to a specific time (e.g. 4pm) and the MJ> transactions between 4am to 6pm can be preserved? Or it is just MJ> impossible to do so? Thanks in advance for any input. Thats easy - restore it from your backups of course! Tim -- Tim Cross The e-mail address on this message is FALSE (obviously!). My real e-mail is to a company in Australia called rapttech and my login is tcross - if you really need to send mail, you should be able to work it out!