HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
recyclebinthelatestfiguresectionversionsqlhowdeveloperout

Problem

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).

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.