Re: Unable to recover a drop table from recyclebin?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 01 May 2007 16:02:20 -0700
Message-ID: <1178060538.686991@bubbleator.drizzle.com>

Maxim Demenko wrote:
> DA Morgan schrieb:

>>
>> FLASHBACK TABLE "<recyclebin_name_not_original_name>
>> TO BEFORE DROP;
>>

>
> ???
>
> Best regards
>
> Maxim

Does this help?

SQL> create table t (

   2 testcol varchar2(20));

Table created.

SQL> drop table t;

Table dropped.

SQL> select object_name, original_name

   2 from recyclebin;

OBJECT_NAME                    ORIGINAL_NAME
------------------------------ --------------------------------

BIN$PiPfN+acQVy42vRuWDgYmQ==$0 T

SQL> flashback table "BIN$PiPfN+acQVy42vRuWDgYmQ==$0"

   2 to before drop;

Flashback complete.

SQL> desc t
  Name Null? Type
----------- ------------ ------------

  TESTCOL                   VARCHAR2(20)

SQL>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue May 01 2007 - 18:02:20 CDT