Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does TOYS create an optimal synchronization script?

April 26, 2017create optimal Script synchronization TOYS

0

10 Posted

Does TOYS create an optimal synchronization script?

1 Answer

0

Posted

The DDL synchronization script generated by TOYS attempts to be “optimal”. However sometimes it produces additional DDL statements that are not required. The case of handling temporaries during re-naming of objects is discussed in another FAQ. Another example of this is that when an object is being modified and if any grants are different, TOYS re-issues all grants for the object. Generally these do not affect the execution times of the DDL script. Of much greater significance are the [potentially] long running commands that create indexes, enable constraints and copy table data. Given the capabilities of the Oracle server you are targeting, TOYS will attempt to optimize the upgrade process, however, it will not always do so. Here are some cases where TOYS may generate less than optimal DDL.