Home -> Usenet -> comp.databases.oracle -> Re: how to rebuild the system user

Re: how to rebuild the system user

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sun, 17 Nov 2002 14:58:18 GMT
Message-ID: <Xns92C94703AA5D7SunnySD_at_68.6.19.6> 







rafaelo.giovannelli_at_raibakwt.com (rafaelo giovannelli) wrote in
news:c071436.0211170057.4262be60_at_posting.google.com: 



> Ban Spam <ban-spam_at_operamail.com> wrote in message


> news:<Xns92C8A14FB84F5SunnySD_at_68.6.19.6>... 



>> rafaelo.giovannelli_at_raibakwt.com (rafaelo giovannelli) wrote in 
>> news:c071436.0211161157.72089ff0_at_posting.google.com:
>> 
>> > Hallo
>> > 
>> > Several packages from the (Database Oracle 8i) system user are
>> > invalid. I have tried to compile them without success. I think that
>> > I must rebuild the system user.
>> > 
>> > Is this possible and/or is there another way to compile the
>> > packages? 
>> 
>> Yes. Yes.
>> 
>> It really would help if you provided the actual names of the packages
>> which are no longer valid.
>> 
>> Have you searched MetaLink for a solution?
>> If not, please go & do so BEFORE coming back to this forum.
>>




> I have searchd MetaLink and found the gen_comp_all.sql script but it

> did not work. I recived the message:


> 

> Warning: Package Body altered with compilation errors.

> 

> The invalid objects are:

> 

> alter PACKAGE SYSTEM.DBMS_AQ compile;

> alter PACKAGE SYSTEM.DBMS_AQIN compile;

> alter PACKAGE SYSTEM.DBMS_AQJMS compile;

> alter PACKAGE SYSTEM.DBMS_SYS_SQL compile;

> alter PACKAGE SYSTEM.UTL_COLL compile;

> alter PACKAGE SYSTEM.UTL_REF compile;

> alter package SYSTEM.DBMS_ALERT compile body;

> alter package SYSTEM.DBMS_AQ compile body;

> alter package SYSTEM.DBMS_AQADM compile body;

> alter package SYSTEM.DBMS_AQADM_SYS compile body;

> alter package SYSTEM.DBMS_AQIN compile body;

> alter package SYSTEM.DBMS_AQJMS compile body;

> alter package SYSTEM.DBMS_AQ_SYS_EXP_INTERNAL compile body;

> alter package SYSTEM.DBMS_DDL compile body;

> alter package SYSTEM.DBMS_DDL_INTERNAL compile body;

> alter package SYSTEM.DBMS_DESCRIBE compile body;

> alter package SYSTEM.DBMS_EXPORT_EXTENSION compile body;

> alter package SYSTEM.DBMS_IJOB compile body;

> alter package SYSTEM.DBMS_IREFRESH compile body;

> alter package SYSTEM.DBMS_JAVA_TEST compile body;

> alter package SYSTEM.DBMS_JOB compile body;

> alter package SYSTEM.DBMS_LOGMNR_D compile body;

> alter package SYSTEM.DBMS_PICKLER compile body;

> alter package SYSTEM.DBMS_PITR compile body;

> alter package SYSTEM.DBMS_PLUGTS compile body;

> alter package SYSTEM.DBMS_PRVTAQIM compile body;

> alter package SYSTEM.DBMS_PRVTAQIP compile body;

> alter package SYSTEM.DBMS_PRVTRMIE compile body;

> alter package SYSTEM.DBMS_PSP compile body;

> alter package SYSTEM.DBMS_PSWMG_IMPORT compile body;

> alter package SYSTEM.DBMS_RCVMAN compile body;

> alter package SYSTEM.DBMS_REFRESH compile body;

> alter package SYSTEM.DBMS_RESOURCE_MANAGER compile body;

> alter package SYSTEM.DBMS_RMIN compile body;

> alter package SYSTEM.DBMS_RULE_ADM compile body;

> alter package SYSTEM.DBMS_SNAPSHOT compile body;

> alter package SYSTEM.DBMS_SNAPSHOT_UTL compile body;

> alter package SYSTEM.DBMS_SNAP_INTERNAL compile body;

> alter package SYSTEM.DBMS_SQL compile body;

> alter package SYSTEM.DBMS_STATS compile body;

> alter package SYSTEM.DBMS_SUMADV compile body;

> alter package SYSTEM.DBMS_SUMREF_CHILD compile body;

> alter package SYSTEM.DBMS_SUMREF_PARENT compile body;

> alter package SYSTEM.DBMS_SUMREF_UTIL compile body;

> alter package SYSTEM.DBMS_SUMREF_UTIL2 compile body;

> alter package SYSTEM.DBMS_SUMVDM compile body;

> alter package SYSTEM.DBMS_SYS_SQL compile body;

> alter package SYSTEM.DBMS_UTILITY compile body;

> alter package SYSTEM.DBMS_ZHELP compile body;

> alter package SYSTEM.UTL_COLL compile body;

> alter package SYSTEM.UTL_REF compile body;

> 

> Pleas help yours Rafaelo

> 

>> 
>> HTH & YMMV
>> 
>> 
>> HAND!





I could be wrong, but I just checked a couple of my DBs
WRT a few of the packages listed above. On mine the packages
were owned by SYS & not by SYSTEM.
Received on Sun Nov 17 2002 - 15:58:18 CET












Original text of this message