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


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?

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