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.
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.