Skip to Content
0

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

Nov 04, 2016 at 01:57 PM

76

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Nov 09, 2016 at 05:39 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded