Re: Oracle Upgrade Concerns

From: <art_at_chicagorsvp.com>
Date: 23 Jun 2006 10:17:15 -0700
Message-ID: <1151083035.089277.191930@g10g2000cwb.googlegroups.com>

Jining Han wrote:
> I assume you have run catpatch.sql and utlrp.sql scripts after the
> upgrade?
>
> JH

Well, I ran the UITLRP.SQL, and that seemed to take care of all the SYS stuff. But why are all the MATERIALIZED VIEWS invalid??

XML SCHEMA XDB.XD3/uNtPGLYGTgM8BsuBFgZA== has a status of INVALID

MATERIALIZED VIEW MIRS_LOOKUP.AFQT has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.AFQT_PERCENTILES has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.AIR_FORCE_COMP has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.AIR_FORCE_COMPOSITES has a status of

INVALID

MATERIALIZED VIEW MIRS_LOOKUP.ARMY_COMP has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.CHAR_SRVC_CODE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.CNTRY_MEPCOM_USCIS has a status of

INVALID

MATERIALIZED VIEW MIRS_LOOKUP.CNTRY_WORLD has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.CO_US has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.DEATH_SOURCE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.DRUG_TST_EXCEP_CODE has a status of

INVALID

MATERIALIZED VIEW MIRS_LOOKUP.EDUC_DESIG has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.ETHNIC_CATEGORY has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.FORM_AREAS has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.FORM_PARAMETERS has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.ICD_CODE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.ISC_ENL_CODE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.LANG_IDENT has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MARINE_COMP has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MED_FAIL_CODE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MED_HIV_ANTI_SCRN has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MED_LAB has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MED_PERM_FAIL_CODE has a status of

INVALID

MATERIALIZED VIEW MIRS_LOOKUP.MEPS_SYSTEM_INFO has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MIRS_FORMS has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.MIRS_PARAMETER has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.PULHES_ICD has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.RACIAL_CATEGORY has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.SEP_RSN_MIL has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.SPECIAL_TST has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.SPECIAL_TST_AUTH has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STANDARD_SCORES has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STANDARD_SCORE_LIMITS has a status of

INVALID

MATERIALIZED VIEW MIRS_LOOKUP.STATE_OF_US has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STD_DISCREPANCIES has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STP_GRADE_CONSTANTS has a status of

INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STP_GRADE_SEX_PERCENTILES has a status of INVALID

MATERIALIZED VIEW MIRS_LOOKUP.STP_MEAN_DEV_ERR has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STP_PERCENTILES has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STS_ETHNIC_CATEGORY has a status of

INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STS_INTENTIONS has a status of INVALID MATERIALIZED VIEW MIRS_LOOKUP.STS_RACIAL_CATEGORY has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.STS_REPORTS has a status of INVALID MATERIALIZED VIEW MIRS_LOOKUP.STS_SPEC_INSTRUCTIONS has a status of INVALID

MATERIALIZED VIEW MIRS_LOOKUP.TEST_VERSION has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.TRANS_TO_CODE has a status of INVALID
MATERIALIZED VIEW MIRS_LOOKUP.USCIS_WORK_CTZN_STATUS has a status of

INVALID
MATERIALIZED VIEW MIRS_LOOKUP.VALID_SSAN_RANGES has a status of INVALID MATERIALIZED VIEW MIRS_LOOKUP.ZIP_CODE has a status of INVALID Received on Fri Jun 23 2006 - 12:17:15 CDT