Question

Oracle - Refresh materialized view in sequence

  • 15 April 2021
  • 2 replies
  • 4 views

Badge

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

Userlevel 4

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).

Badge

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

Reply