Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 09, 2016 at 05:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded