2 Replies Latest reply: Dec 17, 2012 8:31 AM by 619363 RSS

    How does the recycle bin work

    619363
      Some questions about the recycle bin is SQL Developer.

      1. How do I find the original name of the table? The only name I can see is BIN$...
      2. How do I restore a table in the recycle bin? Do I need to do a "CREATE TABLE ... SELECT * FROM BIN$..."?
      3. Why do some dropped tables not appear in the recycle bin? I accidentally dropped a table, and then, the following week tried to find it in the recylce bin, but looking at the field names, I could see it wasn't there.

      Thanks in advance,
      Dom