/
Oracle Integrity Checks

Oracle Integrity Checks

Sept 25, 2007

MViews

  • Counting objects in both the source as well as the MView table

    • select count(*) from sfrstcr@banner where SFRSTCR_TERM_CODE = '200710'; select count(*) from banner_enrollment where term_code = '200710';