5 Replies Latest reply: May 4, 2012 8:02 AM by steph0h RSS

    undrop table from recyclebin


      On Oracle XE 11g I just tried this:

      flashback table t_tabelle1frak_xls before drop;

      I get this error:

      SQL-Fehler: ORA-00439: feature not enabled: Flashback Table

      Enabling flashback apparently is not possible.

      So I looked for the name of the dropped table in user_recyclebin and created a synonym on the original tablename like:

      create synonym T_TABELLE1FRAK_XLS for "BIN$swkskRSrTN2cPdYZWmvtfg==$0"

      But there must be a better way of undropping a table with disabled flashback?