Oracle Connector 2.0.0.Alpha2
Oracle Connector 1.9.4.Final
A little sanitized, but should be sufficient I hope:
Oracle Database 19c Standard Edition 2 Release 18.104.22.168.0 - Production Version 22.214.171.124.0
Incremental snapshot of the specified table DATA.BIZ.GRP.SCHEMA.CREDENTIAL_TYPES
I see an error that the schema of the table DATA.BIZ.GRP is not found. The connector suggests valid table names, which again includes the table I specified. Obviously, using the suggested names leads to the same error.
It looks to me like periods in database names can't be parsed or more specifically the parsing only uses the first three entries when splitting the table name by period.
(You might be asked later to provide DEBUG/TRACE level log)
How to reproduce the issue using our tutorial deployment?
- Set up an Oracle Database with periods in the name, e.g. DATA.BIZ.GRP
- Create any table within any schema
- Try to perform an incremental snapshot of that table