Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    5

    Question Unanswered: SAP to Oracle automatic data updation

    Hi!

    For outbound/inbound interface, our SAP consultants maintain Z tables in SAP..They would like to have a REPLICA of this Z table in Oracle means with table in SAP, same time it should REPLICATE the data in ORACLE table. I would appreciate if anyone can suggest a way to implement this function. This is urgently required, since the oracle database is also being used by many users, who do not access the SAP.

    Thanks in advance,

    Brillian

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Maybe you could create a copy of the table, and create triggers on it so all data manipulation on the original table will also be applied to the copy.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: SAP to Oracle automatic data updation

    Originally posted by brillian
    Hi!

    For outbound/inbound interface, our SAP consultants maintain Z tables in SAP..They would like to have a REPLICA of this Z table in Oracle means with table in SAP, same time it should REPLICATE the data in ORACLE table. I would appreciate if anyone can suggest a way to implement this function. This is urgently required, since the oracle database is also being used by many users, who do not access the SAP.

    Thanks in advance,

    Brillian
    Read up on Oracle's replication function - that's exactly what it is for:

    http://technet.oracle.com/doc/oracle...over.htm#12888

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •