Re: how to rebuild the system user

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!
Received on Sun Nov 17 2002 - 09:57:47 CET