Replication Agent and selecting field names with special characters from Oracle PDS
I have SAP Replication Server SP200 set up and working from Oracle to HANA. I'm creating a subscription with the direct_load option on the SAP table MARA. This is failing at the "SELECT" stage with the Oracle error "ORA-00936: missing expression". This is because the MARA table contains a few fields that begin with a forward slash e.g. /BEV1/LULEIHN. In order for this to work each field name needs to be enclosed in double quotes ("/BEV1/LULEIHN"). Does anybody know if there is an option in Replication Server to make it use double quotes in select statements?
If not I'll end up creating views for all the tables containing special characters.
I've now got this working but setting the dsi_quoted_identifier to "always" when creating both primary and replicate connections. The syntax I used was as follows:
create connection to pds.pdb
using profile <profile_name>
set username <username>
set password <password>
set dsi_quoted_identifier to "always"