Property | Version | Use |
|---|---|---|
AllowDistributedTransactions | 10g, 11g, 12c, 19c | If set to true (default), distributed transaction processing is allowed. |
Code Page | 10g | The code page translation table tells the integration platform which encoding to use for reading and writing data. The default is ANSI, which is the standard in the US. For the supported list, see CodePage. |
Directory Alias | 10g, 11g, 12c, 19c | Allows you to specify the name of the Directory Alias. There is no default. |
Encoding | 11g, 12c, 19c | Determines how to store characters in Oracle 11g, 12c, and 19c target files. Default is OEM. For encoding choices, see Source and Target Map Connectors. |
SQL Log | 10g, 11g, 12c, 19c | The default is sql.log in the default installation directory. To use a different log, browse to the file, or enter the path and file name. Note: SQL statements are sent to the SQL Log file only if the SQL Output property is set to either Target and SQL Log or SQL Log Only. |
SQL Output | 10g, 11g, 12c, 19c | Allows you to select bound or unbound mode and whether you want to write SQL statements to a SQL log or not. Keep in mind that bound mode is faster, since bind variables are used. • Target Only – Uses bound mode, which uses bind variables. SQL statements are sent to the Target and not to the SQL log specified in the SQL Log property. Default. • Target Only (Unbound Mode) – Uses unbound mode, which does not use bind variables and sends the literal SQL statement to the database engine. SQL statements are sent to the Target and not to the SQL log specified in the SQL Log property. • Target and SQL Log – Sends SQL statements to the Target and to the SQL log specified in the SQL Log property. • SQL Log Only – Sends SQL statements only to the SQL log file specified in the SQL Log property. |
Synonyms | 10g, 11g, 12c, 19c | If set to true, allows you to see synonyms. The alias names appear in the table list along with the tables. Default is false. |
SystemTables | 10g, 11g, 12c, 19c | If set to true, this property allows you to see all tables created by the DBA in the database. The system table names appear in the table list. Default is false. |
UpdateNullFields | 10g, 11g, 12c, 19c | Null values are sent to the database when inserting or updating records. The default is true. If you select False, null values are not sent to the database when you insert or update records. When set to false, this property forces the connector to operate in unbound mode, which may cause slower performance. Best Practice — If fields in the target record are not mapped, then the null values are passed to the target. If you do not want to write to these fields, then it is recommended to set the value for UpdateNullFields to False. |
Views | 10g, 11g, 12c, 19c | If set to True, this property allows you to see the view names in the table list along with the table names. Default is True. Note: This property supports only Append and DeleteAndAppend output modes and does not support the Replace output mode. |
Name | Syntax | Notes |
|---|---|---|
VARCHAR2 | (size[BYTE|CHAR]) | Variable-length character string having maximum length of size bytes. Maximum size is 4000 bytes and minimum is 1 byte. You must specify size for VARCHAR2. BYTE indicates the column has byte length semantics. |
NVARCHAR2 | (size) | Variable-length character string having maximum length of size bytes. Maximum size is determined by the national character set definition. You must specify size for NVARCHAR2. |
NUMBER | (p,s) | Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127. |
LONG | N/A | Character data of variable length up to 64000 bytes. |
DATE | N/A | Valid date range from January 1, 4712 BC to December 31, 9999 AD. Note: DATE data type is referred as DATETIME in Oracle connectors. |
BINARY_FLOAT | N/A | 32-bit floating point number. This data type requires 5 bytes, including the length byte. |
BINARY_DOUBLE | N/A | 64-bit floating point number. This data type requires 9 bytes, including the length byte. |
TIMESTAMP | (fractional_seconds_precision) | Year, month and day values of date, as well as hour, minute and second values of time, where fractional_seconds_precision is the number of digits in the fractional part of the SECOND datetime field. Accepted values of fractional_seconds_precision are 0 to 9. The default is 6. |
TIMESTAMP with TIMEZONE | (fractional_seconds_precision) | All values of TIMESTAMP as well as TIME ZONE displacement value, where fractional_seconds_precision is the number of digits in the fractional part of the SECOND datetime field. Accepted values are 0 to 9. The default is 6. |
TIMESTAMP with LOCAL TIME ZONE | (fractional_seconds_precision) | All values of TIMESTAMP with TIME ZONE, with the following exceptions: • Data is normalized to the database time zone when it is stored in the database. • When the data is retrieved, users see the data in the session time zone. |
INTERVAL YEAR TO MONTH | (year_precision) | Stores a period of time in years and months, where year_precision is the number of digits in the YEAR datetime field. Accepted values are 0 to 9. The default is 2. |
INTERVAL DAY TO SECOND | (day_precision) (fractional_seconds_precision) | Stores a period of time in days, hours, minutes and seconds, where • day_precision is the maximum number of digits in the DAY datetime field. Accepted values are 0 to 9. The default is 2. • fractional_seconds_precision is the number of digits in the fractional part of the SECOND field. Accepted values are 0 to 9. The default is 6. |
RAW | (size) | Raw binary data of length of size bytes. Maximum size is 2000 bytes. You must specify size for a RAW value. |
LONG RAW | N/A | Raw binary data of variable length up to 2 GB. |
ROWID | N/A | Base 64 string representing the unique address of a row in its table. This data type is primarily for values returned by the ROWID pseudocolumn. |
UROWID | [(size)] | Base 64 string representing the logical address of a row of an index-organized table. The optional size is the size of a column of type UROWID. The maximum size and default is 4000 bytes. |
CHAR | (size [BYTE|CHAR]) | Fixed-length character data of length of size bytes. Maximum size is 2000 bytes or characters. Default and minimum size is 1 byte. BYTE and CHAR have the same semantics as VARCHAR2. |
NCHAR | (size) | Fixed-length character data of length of size characters. Maximum size is determined by the national character set definition, with an upper limit of 2000 bytes. Default and minimum size is 1 character. |
CLOB | N/A | A character large object containing single- or multibyte characters. Both fixed and variable-width character sets are supported, both using the database character set. Maximum size is (4 GB - 1 byte) * (database block size). |
NCLOB | N/A | A character large object containing Unicode characters. Both fixed-width and variable width character sets are supported, both using the database national character set. Maximum size is (4 GB - 1 byte) * (database block size). Stores national character set data. |
BLOB | N/A | A binary large object. Maximum size is (4 GB - 1 byte) * (database block size). |
BFILE | N/A | Contains a locator to a large binary file stored outside the database. Enables byte stream I/O access to external LOBs residing on the database server. Maximum size is 4 GB. |