How to see restored database items?

[Matthew F.]

Hi Folks:
I have a schema that had many items restored from the recylebin several years ago. I want to clean them up but am unsure how to see the duplicate restored items in PL/SQL Developer.
Here is an example:

In PL/SQL Developer (latest Edition):

In another program:

Is there a way to display all the triggers in PL/SQL Dev?
Thanks, Matthew

 

[Marco Kalter]

In PL/SQL Developer you can open the "Recycle bin" folder to see these objects. Right-click on them and select "Purge" to delete them permanently.

 

[Matthew F.]

Hi Marco:

As the title of the question indicated, these are not items in the recylebin, but items that have been restored.

When they were restored a couple of years ago the person who restored them left the generic system generated name beginning with BIN$.....

These show up in other Oracle IDE's but not in PL/SQL Developer. I can log into the other IDE's to compare them and delete or rename them as needed, but I just wanted to verify that I wasn't missing something that would allow viewing them in PL/SQL Developer.

(They are not in the recylebin and I have the settings set to show all objects).

Matthew

 

[William Robertson]

I see the problem. When you restore a dropped table using

flashback table yourtable to before drop;

the original table name is restored, but any indexes, constraints, triggers etc retain their BIN$ prefix despite no longer being in the recyclebin. It seems PL/SQL Developer excludes anything prefixed BIN$ to avoid an explicit check against the recyclebin. Unfortunately in this scenario valid objects are therefore not visible in the browser.