Finding objects NOT in the recycle bin.
This one is a bit odd, I know, but bear with me.
To keep our Developers happy, I've written a utility that allows them to "fill" development schemas using object definitions/ data from other [better-managed] schemas. In order to do this, I needed to clear out whatever they've got in their target schema before importing the new "stuff" that they want.
I took great pleasure in creating a procedure called obliterate_schema that drops everything in the target schema.
Or, at least, it did until it hit an object that was owned by the targe schema (and, suppoedly, eligible for dropping) but that was already in the recycle bin.
To keep our Developers happy, I've written a utility that allows them to "fill" development schemas using object definitions/ data from other [better-managed] schemas. In order to do this, I needed to clear out whatever they've got in their target schema before importing the new "stuff" that they want.
I took great pleasure in creating a procedure called obliterate_schema that drops everything in the target schema.
Or, at least, it did until it hit an object that was owned by the targe schema (and, suppoedly, eligible for dropping) but that was already in the recycle bin.
0