3

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped the last (I mean the last version of the table).

enter image description here

I can not restore all of them cause there can not be tables with the same name in tables section and I can not see the properties of the tables in recyclebin either . What is the best way to find the latest version of a table in recyclebin?

Important thing is that think about a situation in which the table has nearly more than 300 columns and it's not a good solution to restore the tables one by one to check whether it's the latest one . I want to know if there is a solution that for one hundred percent returns the latest version of the table from the recyclebin.

Thanks in advance

Improve this question
3
  • 1
    Can't you just restore one of the three, check if it's OK and then DROP it if not? If it's not OK, then maybe you could TRUNCATE it so it doesn't reappear in the recycle bin? Warning: I am not familiar with the recycle bin in this context nor how it works - have only looked at allroundautomations' PL/SQL Developer product once and that was a long time ago!
    – Vérace
    Jul 21, 2020 at 7:00
  • @Vérace In this scenario I'm familiar with the structure of the table. I'm actually asking this for situation in which the table has , for instance nearly 300 columns and you want to make sure that by doing the right thing , you have access to the latest version of the table.
    – Pantea
    Jul 21, 2020 at 7:05
  • @Vérace I have just edited my question and added a note regarding this.
    – Pantea
    Jul 21, 2020 at 7:08

1 Answer 1

Reset to default
3

The DROPTIME and DROPSCN columns in the DBA_RECYCLEBIN view clearly show when the object was dropped. Stop relying on a simplified GUI.

Improve this answer
3
  • Thanks for your brilliant answer . I did not know that .Just a question . How can we restore the table ? cause according to this table "User Recyclebin" we can see the drop date but how can find out which table to restore?? See , we find the record that has the latest drop date , but how do you restore the table??
    – Pantea
    Jul 21, 2020 at 11:26
  • 1
    @PanteaTourang A specific version of the table can be recovered by referencing the BIN$... name of that table as FLASHBACK TABLE BIN$... TO BEFORE DROP;
    – Balazs Papp
    Jul 21, 2020 at 12:45
  • 1
    @PanteaTourang maybe suggest this on the Allround Automations forum :)
    – William Robertson
    Jul 21, 2020 at 21:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.