Oracle Audio Technologies B31679-01 manual Converting data types to Oracle data types

Converting data types to Oracle data types

Note: If you intend to use your data store with TimesTen Cache Connect to Oracle, you must convert your data types to Oracle data types. However, you will not be able to perform an online upgrade using replication.

To convert the data types from a release prior to TimesTen 7.0 to Oracle data types, you must use the -convertTypesToOraoption for ttMigrate when you restore your data store as part of your upgrade procedure. For example, if you restore the data store salesdata as part of an upgrade procedure, you may use the following to upgrade the data types to Oracle data types:

ttMigrate -r -convertTypesToOra salesdata salesdata.mig

See “TimesTen to Oracle data type conversions” on page 148 in the Oracle TimesTen In-Memory Database API Reference Guide for more information.

Note: Because the Oracle and TimesTen versions of some data types behave slightly differently, you should thoroughly test any applications written for versions of TimesTen prior to 7.0 with the new Oracle data types before deploying them with TimesTen 7.0.

Upgrading data types as TimesTen data types

Note: If you intend to perform an online upgrade using replication, you must upgrade your data types as TimesTen data types. See “Online upgrades with replication” on page 94 for more information.

If you choose to upgrade the data types in a data store from a version prior to TimesTen 7.0 as TimesTen data types, you do not need to use any special options when restoring the data store with ttMigrate. The data types from a version prior to TimesTen 7.0 will automatically be restored as TimesTen data types.

Note: The default TypeMode attribute for data stores in TimesTen 7.0 is 0, which indicates that standard data type names, such as CHAR, will refer to the Oracle versions of the data types. In order to guarantee compatibility with applications written for TimesTen versions before 7.0, you should configure the DSN for your data store with a TypeMode of 1 before restoring the data store with ttMigrate as part of the upgrade procedure.

90Oracle TimesTen In-Memory Database Installation Guide