Forum Discussion

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

that's technically impossible. You cannot extract the data from Oracle without any performance impact. 

 

I don't know to what extent you can control your Oracle database - you could theoretically explore triggers there that would automatically push the rows upon inserts. 

 

Where does the Oracle database get the live data from?

razieh1990's avatar
razieh1990
Icon for Helper I rankHelper I
2 years ago

Thanks for your reaponse.

the oracle gets data from external system.

I every second a lot of rows are inserted in database.

there is a video on youtube and I'd like to analyze the potential risk on oracle before implementing it.

https://youtu.be/vpD_PKtcTj8?si=BvALkZsN_uEPWnEn

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    have the external system push the rows into the streaming dataset. Note that there are size limits - a streaming dataset won't hold more than 5 million rows.

    • razieh1990's avatar
      razieh1990
      Icon for Helper I rankHelper I
      2 years ago

      Thanks for your response. Are there any articles or sources I can read and know how to push the rows into the streaming dataset?  I don't have knowledge to do it and would like to know how to do it 

      much appreciated