Why is my plsql code missing in the datadictionary in Oracle 12c?
Last week I was fortunate enough to have the opportunity to speak with Tom Kyte. And since he is the Tom from AskTom, I did just that: I asked him about this problem. I explained what I wrote above and asked him: "what did I do wrong?"
And his answer was plain and simple: "Probably nothing". He explained that 12.1.0.1 had a couple of bugs in the datadictionary views because suddenly they had to get a part of their data from the container database and a part from the plugged-in database. So, it Tom concluded I probably ran into one of hose bugs.
Still, since nobody could confirm this behaviour, and since I can not imagine being the only one ever using a 12.1.0.1 database, I feel that there must be something I did that triggered this bug to be noticeable.
Anyway, now that I am assured that the problem probably lies within the product, I will stop investigating it further and upgrade to 12.1.0.2. Now, if the upgrade makes the problem disappear, I will be confident that it will not reappear a week later after me repeating my 12.1.0.1 stupidity.
Edit 25/02:
Last weekend deinstalled 12.1.0.1 and installed 12.1.0.2 following the exact same steps I used for 12.1.0.1. Problem is gone. So it looks like Tom was right (once again).