on 10-16-2015 11:52 AM
Hello.
We had added several tables to our sid-by-side HANA with HANA studio.
Now we finally want to delete one table (e.g. LIKP) from the replication in SLT and HANA (data provisioning), because we no longer need that table.
What steps must be done in source system, SLT and/or HANA Studio to delete all depending objects of the table (e.g. LIKP) and/or eintries in other tables?
We found lot of objects (e.g Trigger, function modules, ddic objects (e.g. tables with name /1CADMC/nnnnnnnn).
Source system: ECC6; DMIS 2011_1_731 SP04 (upgrade to SP09 in november)
SLT: same DMIS as in ECC6
Where can we find any step-by-step documentation to remove a table from replication and delete all depending objects?
Best regards.
Jürgen.
Thank you all.
As i read in the blog there no automaticly check tool exists
Then i have to check it manually.
Where can we find any Information about an error in HANA. We have often Problems with tables that are replicated into HANA. I only see in data provisioning "error". I cant find why this error occurs and what ist to do to fix the error.
In the log files there is no entire found.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jurgen,
Easiest way is to 'stop replication' for the table (I am assuming that the SLT configuration will still be active for the tables that you need). The 'stop' will remove the triggers and logging tables from the source system and also from the SLT mass transfer ID...you can perform these steps from HANA Studio (if authorized) or from transaction LTRC in the SLT.
Then, in HANA Studio, find the table (if still there) in the relevant schema, right-click and 'delete' with the cascade option as that will remove the table, data and any associated objects.
Hope this helps.
Kris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.