library cache lock when compilling a procedure
Guess2May 4 2009 — edited May 5 2009I just created a brand new database.
I am doing a full import.
The import hangs on a library cache lock when it is compiling 1 procedure.
all the procedure is doing is inserts, select for update, and selects. Nothing fancy at all.
No one else is connected to the database.
I actually had another database that i had just created and I got the same wait on the same procedure.
I tried to compile the procedure manually(killed the import, logged into the appropriate schema)...
this is in 10.1.0.3 on Solaris. I cannot upgrade past 10.1.0.3 at the moment. I am not allowed.
This was an export from the same version on hp-unix.
I am stumped. is there any way to do an import from a full export and exclude a schema? I want to get the rest of my import done and then solve this. This package doesn't even work in the database that I am exporting it from. it is invalid.