PLS-907 cannot load library unit

Question

Following is my oracle version Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

I was trying to alter a table to add a column but since it took long time, i cancelled it.

After sometime, i started seeing errors in all packages and views that referenced the unit. Error message is

PLS-907: cannot load library unit (table name)

Googling on this error does not give much information. In one place, i saw that below command will help but it seems to me as very risky command

alter system flush shared_pool

Can anyone help me with the reason and solution to this?

Thanks, Jeevan

Answer 1

it happens because of DB links are dropped and recreated for connections so just recompiling the package will resolve this and some times it automatically recompile it .