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).
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
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP