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.

Why is the RDBMS version important?

April 26, 2017RDBMS version

0

10 Posted

Why is the RDBMS version important?

1 Answer

0

Posted

TOYS considers the version of Oracle to determine the support for manipulating objects. For example, can indexes and constraints be re-named? Can table columns be dropped, re-named etc.? Since these capabilities vary from version to version of the Oracle server, TOYS will generate the appropriate DDL commands for the nominated version of Oracle. Because Oracle has [generally] maintained “upward” compatibility, a script generated against 8.0 will run against both 8.0, 8i and 9i. This assumes that you only use 8.0 features. The price you pay for explicitly forcing TOYS to generate a script to run against an earlier version of Oracle is that the synchronization process may operate less than optimally against the later version. If for example, TOYS needs to re-name some primary keys, then with an RDBMS prior 9iR2 the constraints must be dropped and then re-created. If any of these primary keys belongs to an index organized table (IOT) then the table must be re-built.