?
Solved

ORA-00907 Cannot load library unit SYS.SYS_STUB_FOR_PURITY_ANALYSIS

Posted on 2010-08-26
3
Medium Priority
?
2,941 Views
Last Modified: 2013-12-19
Cannot compile a simple oracle procedure...it's in one database and connected to another via dblink...error is
PLS-00907: cannot load library unit SYS.SYS_STUB_FOR_PURITY_ANALYSIS@NLDB_REMOTE_CONNECT.NL.EDU
(referenced by BANINST1.F_STUDENT_GET_DESC@NLDB_REMOTE_CONNECT.NL.EDU)

the dblink user HAS execute privs on the sys.sys_stub_for_purity_analysis package!!

Many OTHER load procedures in the same schema using the same dblink...DO compile...any thoughts?
0
Comment
Question by:ScoutsDad
  • 3
3 Comments
 

Author Comment

by:ScoutsDad
ID: 33531717
Attached is the load plsql procedure that will not compile...oracle version is 10.2.4.0
file.sql
0
 

Accepted Solution

by:
ScoutsDad earned 0 total points
ID: 33541339
OK...found the solution to this:

The buffer_cache was full!...i.e. when the error message said it couldn't load the sys module: SYS.SYS_STUB_FOR_PURITY_ANALYSIS...it was due to the fact that the buffer_cache was full...for once...the error message was literally telling me what the problem was...ha!

so a quick alter system flush buffer cache...resolved the issue...!!!!
0
 

Author Closing Comment

by:ScoutsDad
ID: 33541354
I found my own solution...but that's ok that no one else chimed in...this one was a doozy....
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
This video shows how to recover a database from a user managed backup
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question