Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Exclamation Unanswered: errors with upgrading from 9.2.0.2 to 9.2.0.4

    hi,

    I upgraded my database v9.2.0.1 running on win2003 to v9.2.0.4

    but after the process is completed, I have invalid objects when running dba_errors.

    I think the most of the invalid objects have something to do with replication manager, but I don't have it, don't need it and don't want it...

    Can anyone tell me how to solve this?
    thanks

    greets
    ks

    these are the invalid objects:
    OBJECT_NAME OBJECT_TYPE
    ------------------------------ ------------------
    DBA_CACHEABLE_NONTABLE_OBJECTS VIEW
    DBA_CACHEABLE_OBJECTS VIEW
    DBA_CACHEABLE_OBJECTS_BASE VIEW
    DBA_IAS_GEN_STMTS VIEW
    DBA_IAS_GEN_STMTS_EXP VIEW
    DBA_IAS_OBJECTS_BASE VIEW
    DBA_IAS_OBJECTS_EXP VIEW
    DBA_IAS_POSTGEN_STMTS VIEW
    DBA_IAS_PREGEN_STMTS VIEW
    DBA_REGISTERED_MVIEW_GROUPS VIEW
    DBA_REGISTERED_SNAPSHOT_GROUPS VIEW
    DBA_REPEXTENSIONS VIEW
    DBA_REPSITES_NEW VIEW
    DBA_TEMPLATE_REFGROUPS VIEW
    DBA_TEMPLATE_TARGETS VIEW
    DBMSOBJG PACKAGE BODY
    DBMSOBJG2 PACKAGE BODY
    DBMSOBJGWRAPPER PACKAGE BODY
    DBMSOBJG_DP PACKAGE BODY
    DBMS_APPLY_ADM PACKAGE BODY
    DBMS_APPLY_ERROR PACKAGE BODY
    DBMS_DEFER PACKAGE
    DBMS_DEFER PACKAGE BODY
    DBMS_DEFER_INTERNAL_QUERY PACKAGE BODY
    DBMS_DEFER_INTERNAL_SYS PACKAGE BODY
    DBMS_DEFER_QUERY PACKAGE
    DBMS_DEFER_QUERY PACKAGE BODY
    DBMS_DEFER_SYS_PART1 PACKAGE BODY
    DBMS_IAS_INST PACKAGE BODY
    DBMS_IAS_INST_UTL PACKAGE BODY
    DBMS_IAS_INST_UTL_EXP PACKAGE BODY
    DBMS_IAS_MT_INST PACKAGE BODY
    DBMS_IAS_TEMPLATE_INTERNAL PACKAGE BODY
    DBMS_IAS_TEMPLATE_UTL PACKAGE BODY
    DBMS_LOGREP_DEF_PROC PACKAGE BODY
    DBMS_OFFLINE_RGT PACKAGE
    DBMS_OFFLINE_RGT PACKAGE BODY
    DBMS_STREAMS_ADM_UTL PACKAGE BODY
    DEFCALL VIEW
    DEFCALLDEST VIEW
    REPCAT_REPCOLUMN_BASE VIEW
    REPCAT_REPFLAVOR_COLUMNS VIEW
    REPCAT_REPOBJECT_BASE VIEW
    _ALL_REPCOLUMN VIEW
    _ALL_REPCOLUMN_GROUP VIEW
    _ALL_REPCONFLICT VIEW
    _ALL_REPEXTENSIONS VIEW
    _ALL_REPGROUPED_COLUMN VIEW
    _ALL_REPPARAMETER_COLUMN VIEW
    _ALL_REPRESOLUTION VIEW
    _ALL_REPSITES_NEW VIEW
    _DEFTRANDEST VIEW
    52 rows selected.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Why not drop the users that own those objects?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48
    because the owner is sys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •