2 Replies Latest reply: Feb 5, 2013 10:06 AM by Merlin128 RSS

    Restore from Recycle Bin

    Merlin128
      Oracle Enterprise Database 11.1.0.7 and 11.2.0.1

      If I drop a table, it drops the associated Index and triggers..
      the table shows up in the Recycle Bin..

      If I restore the table (keeping the original name)
      the index or trigger comes back with it, but they dont go back to their original names..
      they become BIN$************************* (random text)

      and I have to drop and recreate them to get their names back..

      how do I get them back with thier original names too.. (besides using flashback or restoring from a dump)
      just wondering if I am using the recycle bin incorrectly..