> To avoid such error, try to change the DDL transaction parameter to WAIT
> instead of NO WAIT.

While this would avoid the error, you will not know when/if your change will be applied.

A connection can hold an object in use for an indeterminant period of time.

For me, I want to know that the change will apply/has been made, if not, I will track down the source of the problem... and then re-run.


Sean