TimestampTzFormat
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [StartUp] |
Abbreviation | None |
DBMS | Oracle |
Required? | No |
Valid values | Any valid Oracle datetime format mask For example:
|
Default value | none |
Usage
Specify a valid Oracle datetime format mask that matches the timestamps and time zones in your input.
Consider the following points regarding this parameter:
Use this parameter when your input was generated on a DBMS other than Oracle (or in a different Oracle environment) that uses a different timestamp with time zone format than the format of the timestamp columns in your target tables. When you specify this parameter, High-speed Apply Engine issues an ALTER SESSION SET statement to change the timestamp with time zone format (the nls_timestamp_tz_format parameter).
For valid datetime format masks, consult the Oracle DBMS technical documentation.
High-speed Apply Engine uses this parameter only when the target version of the Oracle DBMS is 9i or later. For earlier versions, High-speed Apply Engine ignores this parameter.
Comments
Log in or register to comment.