90
Oracle TimesTen In-Memory Database Installation Guide
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
-convertTypesToOra
option 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.
