Skip to Content
author's profile photo Former Member
Former Member

Deleting Triggers in Oracle

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 20, 2013 at 06:02 PM

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


    Access Plan.PNG (6.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.