snippetMinor
How to figure out the latest version of a table in the 'recyclebin' section of PL-SQL developer
Viewed 0 times
recyclebinthelatestfiguresectionversionsqlhowdeveloperout
Problem
There are three tables with the same name
I can not
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
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).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
Solution
The
DROPTIME and DROPSCN columns in the DBA_RECYCLEBIN view clearly show when the object was dropped. Stop relying on a simplified GUI.Context
StackExchange Database Administrators Q#271320, answer score: 3
Revisions (0)
No revisions yet.