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: Oracle rman SCN

Re: Oracle rman SCN

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 10 Apr 2007 17:16:39 +0200
Message-ID: <461baa52$0$13852$ba620e4c@news.skynet.be> 






> Also if you are on 10G and your goal is to restore the table

> before the drop you can always use the command

>

> flashback table orders to before drop;

>

> instead of going will a full rman restore.

>

> HTH


> Scott

>




Or maybe the table is still in the recycle bin : SELECT * FROM 
DBA_RECYCLE_BIN;



Matthias 
Received on Tue Apr 10 2007 - 10:16:39 CDT












Original text of this message













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