When trying to upgrade my database from 10gR2 to 11gR2 the upgrade aborts when running the " ?/rdbms/admin/xdbuuc2.sql " portion of the upgrade. I figured this out by performing a manual upgrade and spooling the output to a upgrade.log. Running the " xdbuuc2.sql " was the last thing it before it aborted the upgrade.
I then looked into the " xdbuuc2.sql " SQL script and it states " This procedure checks for non-system (user) dependents of a schema and raises an error if any are found. This will abort upgrade "
So I'm fairly confident this is the cause of my problem. My question is, how can I identify these dependencies and remove them.