This discussion is archived
2 Replies Latest reply: Feb 5, 2013 8:06 AM by Merlin128 RSS

Restore from Recycle Bin

Merlin128 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points