You can translate the question and the replies:

What is the impact of replacing a view (Wrapper\Table)?

What exactly happens when CREATE OR REPLACE WRAPPER and\or CREATE OR REPLACE TABLE is executed? I'm supposing it will lock the view for a short amount of time, milliseconds, queries depending on this replaced view will be delayed.
15-06-2023 03:09:38 -0400

1 Answer

Hi, The **OR REPLACE** modifier in a table specifies that, if there is a base view with the name indicated, it will be replaced by the new view. If you replace an existing view, the query capabilities of the derived views may change (e.g. due to the addition of another field or a query restriction that did not previously exist). This may affect the derived views of this base view. The **OR REPLACE** modifier in a wrapper, when there is already a wrapper with the same name, its definition is replaced by the new one. Hope this helps!
Denodo Team
16-06-2023 05:47:45 -0400
You must sign in to add an answer. If you do not have an account, you can register here