Skip to main content
Question

Oracle - Refresh materialized view in sequence


roberto
Contributor
Forum|alt.badge.img+6

Hello,

I need to refresh six materialized views (Oracle) in sequence. Each refresh must start only after completion of the previous one. Is a chain of SqlExecutor the correct approach or FME will try launching other sqlexecutors without waiting Oracle response? I've noticed that more than one seems to be active at same time.

Suggestions?

TIA

Roberto

2 replies

david_r
Evangelist
  • April 15, 2021

A chain of SQLExecutors should work, as long as the code it executes is synchronous, i.e. that it only returns a result once it has fully completed.

A number of features entering a single SQLExecutor are executed in order, not in parallel (unless you really want it to, using a custom transformer).


roberto
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • April 15, 2021

Hi @david_r​ ,

maybe the idle icon in the transformers made me worried for no reason.

In fact all of them change as completed, as usual, only when the last sqlexecutor completes the run.

Unfortunately not easy to check in Oracle client.

Thanks!

Roberto


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings