SAP LT ReplicationServer - DB Oracle Source in read-only mode

[Former Member]

Hello community,

Please, I'd like to know if is possible replicate tables using LT ReplicationServer with a DB Oracle as a Source but it's read-only mode.

We need to replicate some tables from Oracle to HANA but the database is read-only mode (db stand-by).

[sudipDas · Accepted solution]

Hi

I have faced the same requirement. But unfortunately its not possible .

To configure SLT you have to have a write authorization in Source system to perform the below activity.

1. to establish a connection (create session) to the database.

2. to connect to a specific schema from the database.

3. to properly replicate and initially load for a specific table from a given schema, the database user that you have used for establishing connection to the database must have permission to: - Select from the specific table - Create a table in the given schema (in order to successfully create the logging table) - Select from the logging table - Delete the logging table - Create database triggers for the specific table - Delete the database triggers - Create synonyms and views for the specific table - Delete the synonyms and the views.

Please refer the OSS note - 1771460.

Regards

Sudip