2 Replies Latest reply on Feb 5, 2013 4:06 PM by Merlin128

    Restore from Recycle Bin

      Oracle Enterprise Database and

      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..