Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

user_source and all_source does not contain some of the code

774414Nov 30 2011 — edited Nov 30 2011

Hi all,

I did not see a similar question here, I have a strange situation: when I query the user_source and all_source data dictionary views, the text source of some of my packages is missing.

example:
SELECT *
FROM all_source ac
WHERE ac.OWNER = 'MYSCHEMA'
AND ac.TYPE = 'PACKAGE BODY'
AND ac.name = 'MYPACKAGENAME'

I get the first 9 lines of my package. I was not able to find some information on this. Is it possible that the data dictionary views are corrupted? What can I do to fix this?

Oracle is:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options

This post has been answered by Billy Verreynne on Nov 30 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2011

Added on Nov 30 2011

#database, #dba, #general-database-discussions

4 comments

3,739 views