on 02-13-2015 9:25 PM
Hi -
Using Oracle 11g and SLT 2011_1_731 Patch 7 with Hana rev 82
I am trying to replicate oracle views in hana through SLT
Scenario 1:
tables T2 and T3 with View T2_T3_view
It creates the view as a table in hana but does not populate it with any data.
Scenario 2 -
I have 2 oracle tables - T4 and T5. I have a view T4_T5_VIEW that joins the 2 tables.
I followed steps in a document I received to replicate the view syntax as well as the tables.
1) replicated both tables T4 and T5 - success
2) stopped replication on T4
table exists in hana with data but no replication
3) using LTRS, assigned the view T4_T5_VIEW to table T4
4) changed the performance option
5) restarted replication on T4
The view gets created as a table, but table T4 gets and error and does not replicate.
The view gets no data
What is the proper process for an oracle table?
I have a very complex view with 5 source tables I want to replicate.
Thanks
Diane
Hi,
Have you ever solved this issue?
I'm facing similar issue when I'm replicating views from SYBASE ASE.
Regards,
Chong
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Diane,
So far from my experience, it is not possible to replicate a view like you replicate a table.
What you can do is the following:
- Replicate all underlying tables
- After that replicate the view, using the name of the view and the option "Create Table / DB View"
Thus the view is kind of copied to the HANA database and can be used there. Anyhow all changes of the view in the sourcesystem after the "copy" will not be copied automatically into the HANA, you would need to do this manually.
Regards
Konstantin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Diane,
This is Srini. I hope my solution is working fine.
Approach:
Migrate required tables from Oracle to HANA. And identify procedures, functions and cursor used in view. Than create Scripted Calculation views using same cursor logic and combine all views into one output Calculation view.
You need Oracle and HANA skills to complete this work around.
Thanks
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.