cancel
Showing results for 
Search instead for 
Did you mean: 

Deleting Triggers in Oracle

Former Member
0 Kudos

Hello,

   We have HANA connected to Oracle via SLT. Couple of table replications are causing errors, and when we followed the clean up mentioned in SAP documents, the triggers in Oracles are not getting deleted. If it were regular SAP, we could use IUUC_REMOTE to delete the triggers, with Oracle as the source does anyone know how to delete the triggers and log tables? Its is giving -955 ORA errors, and we even tried physically dropping the triggers and it still causing error. Thanks for the help.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This is the initial error we get, and we are not able to address it.

Former Member
0 Kudos

While replicating data from Oracle via SLT and when the table has multiple key; the recommendation was to set reading type to "INDX CLUSTER with FULL TABLE SCAN". Once the option is set in IUUC_PERF_OPTION, the replication went ok.

Answers (0)