I would prefer to be able to run the DDL script without taking peoples Oracle database offline. I'm wondering if something such as "online table redefinition" would help me. I have no experience with this (admittedly not very Oracel knowlwdgable).

Anyone familiar with Online Table Redifinitions?

Is this something that could allow a script to run DDL statements while the database was available and provide a means of recover should one of the DDL statements fail?

Thanks again for the response!!