TransWikia.com

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

Database Administrators Asked by Pantea on October 28, 2021

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

One Answer

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

Answered by Balazs Papp on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP