I have been dropping packages as part of an upgrade from ACS 4.2 to OpenACS 4.6. It is easy to drop the Oracle objects created in the package-create scripts, but so far I have ignored the metadata in ACS.
Has anyone written a script to check the database for orphaned ACS objects? It would be useful to check for permissions, objects and object types that are not referenced anywhere.
