Sample Header Ad - 728x90

How to figure out the latest version of a table in the 'recyclebin' section of PL-SQL developer

3 votes
1 answer
124 views
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
Asked by Pantea (1510 rep)
Jul 21, 2020, 06:22 AM
Last activity: Jul 21, 2020, 08:26 AM