DynamicLoadEnable
This attribute enables or disables dynamic load of data from an Oracle database to a TimesTen dynamic cache group. By default, dynamic load of data from an Oracle database is enabled.
To enable or disable dynamic load at the statement level and temporarily override the setting of this attribute, set the DynamicLoadEnable
optimizer flag with the ttOptSetFlag
built-in procedure or using the statement level optimizer hint TT_DynamicLoadEnable
in a SQL statement.
Note:
The value of this attribute overrides the dynamic load behavior of all dynamic cache groups for the current connection to the database.
Required Privilege
No privilege is required to change the value of this attribute.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set DynamicLoadEnable
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
Not applicable |