Unleash Technology

ORA-00942: table or view does not exist or ORA-00904: Invalid identifier

Error: ORA-00942: table or view does not exist
Reason: This error occurs when new table/view exists in logical schema (Siebel repository) but not present in physical database

Error: ORA-00904: “Field Name”: invalid identifier 
Reason: This is also because of mismatch between logical schema and physical database

How to resolve: To fix both issues, we have to sync physical database with Siebel repository. To do so, Siebel provides DDL Sync utility. DDLsync utility compares the logical schema (schema definition in Siebel repository) with physical schema (physical table/column definitions in database) and applies all differential changes on Physical schema so that both are in sync. But there are exceptional cases as well.
          1. Custom column that is in physical schema but not in Siebel repository (logical schema) will not be deleted
          2. Custom index that is in physical schema but not in Siebel repository (logical schema) will not be deleted

After running DDL Sync utility, if you still face the issue, please let us know. We will try our best to fix it. If you have any other issue, please share with us.
To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.

Sharing is caring!