Troubleshooting > Troubleshooting DataConnect > Table or view does not exist
Was this helpful?
Table or view does not exist
 
Error Code
8
Error Message
executeStatement(StmtExecute): error 942 (ORA-00942: table or view does not exist).
Description
This error may be displayed when the Table Name is not specified using the Advanced Map View option. This error is usually displayed for connectors like Oracle 19c Multimode.
Cause/Solution
 
Cause: The Table Name has not been specified using the Advanced Map View option.
Solution: Add “Transformation started map event from configuration tab:
1. Open the transformation.
2. Click the Configuration tab.
3. Go to Map events section.
4. Add transformation started map event with Drop/Create Table operation.
Related Information
Last modified date: 07/26/2024