Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Replicate from multiple oracle schemas in single instance to hana

Hi -

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.


For example

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

     schema1.table1


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?


Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question