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.

What determines the Oracle version that TOYS chooses when generating DDL?

April 26, 2017chooses DDL generating Oracle TOYS version

0

Posted

What determines the Oracle version that TOYS chooses when generating DDL?

1 Answer

0

Posted

When you capture meta-data, TOYS determines the version of Oracle and records it in the snapshot as part of the meta-data. If you then generate DDL from this snapshot (meta-data), TOYS uses the recorded version to determine the syntax etc. of the generated DDL. When generating DDL, you may override the default setting. If you do so, be aware that this option may not provide all of the functionality that you require. Although the generated DDL is [usually] valid for the target database version, loss of semantic content may result.