Replicate from multiple oracle schemas in single instance to hana
I am replicating Oracle Leasing to Hana and have 50 tables spread across 7 schemas.
I want to use a single Hana schema for the connection.
schema1 has 5 tables
schema2 has 4 tables
User SLT_ADMIN has the following Oracle privs:
- create any table
- create trigger
- select any table
From Hana studio, I try to replicate table
Hana returns message that table has no columns and prefixes table as if it is SLT_ADMIN.SCHEMA1.TABLE1.
In a different test, I create the same tables in the SLT_ADMIN schema and can replicate successfully.
What configuration do I need to setup as SLT_ADMIN to allow me to replicate tables owned by other schemas?