Issue/Question
I am attempting to run a query against Banner ODS and it returns with an error
Error: ORA-00942: table or view does not exist
Environment
- Banner ODS
- Query tool or Cognos SQL query
Cause
The table was previously owned by the ODSMGR schema; with the migration to Exadata storage, a new schema was created ZZ_SDGRP
Resolution
Qualify the table with the new schema name
Use ZZ_SDGRP.ZZ_PAYROLL_DISTRIB_NOPREDICATE instead of the Old schema-table name (ODSMGR.ZZ_PAYROLL_DISTRIB_NOPREDICATE)