When referencing a schema that is updated every few minutes from another schema (with MV, etc.), referencing the table being processed will occasionally cause an error. Considering the transaction, I think that the error will not occur if you refer to the data before updating until the processing is completed, and refer to the data after processing after processing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.