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

Direct Load Path To One Partition in Destination Table - Oracle

Hello,

I have one question can anyone describe how or if can be done.

Problem:

SAPDI is loading to ONE target ST_TABLE table (that is partition by one number field "1 or 2 or other").

But it is loading from two separate ETL's.

The problem becomes when loading at same time. First ETL locks the whole table becouse it is written with APPEND then second ETL fails with error:

ORA-02049: timeout: distributed transaction waiting for lock

Solution want to have:

Can it be done to add syntax "partition (1)""

insert /*+ append */ into ST_TABLE partition (PARTITION 1, 2, OTHER) SELECT FIELD1, FIELD2 FROM SOURCE_TABLE

And also want to have push down to database.

This is how we can lock only one partition and not the whole table in Oracle.

But can it be done in SAP Data Services (Have: 4.2 SP07).

Example of dataflow in attachment.

open discussion in wrong forum:

Can anyone help on this?

Best Regards

A.K.

Capture.JPG (125.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 05:51 AM

    I can see that you can enable partition on target table.

    And then reimport table to get definition of partitions on that table.

    But how can i tell now to which partition i will load just to lock that partition and not the whole table becouse of loading other ETL on other partition of same table.

    Best Regards

    A.K.


    Capture2.JPG (49.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

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.