一括取り込みデータベース

前へ次へ

TeradataソースとOracleターゲット

次の表に、TeradataソースとOracleターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示します。

Teradataソースデータ型	Oracleターゲットデータ型
array	blob
bigint	number(19)
blob	blob
byte(`precision`), 1 <= p <= 64000	blob
byteint	number(3)
char(`size`), 1 <= size <= 2000	char(s byte), 1 <= s <= 2000
char(`size`), 2001 <= size <= 64000	clob
clob	clob
date	date
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37	number(p,s), 1 <= p <= 38, 1 <= s <= 37
float	binary_double
integer	number(10)
interval day(`precision`) to hour, 1 <= p <= 4	char(s char), 5 <= s <= 8
interval day(`precision`) to minute, 1 <= p <= 4	char(s char), 8 <= s <= 11
interval day(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	char(s char), 12 <= s <= 21
interval day(`precision`), 1 <= p <= 4	char(s char), 2 <= s <= 5
interval hour(`precision`) to minute, 1 <= p <= 4	char(s char), 5 <= s <= 8
interval hour(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	char(s char), 9 <= s <= 18
interval hour(`precision`), 1 <= p <= 4	char(s char), 2 <= s <= 5
interval minute(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	char(s char), 9 <= s <= 18
interval minute(`precision`), 1 <= p <= 4	char(s char), 2 <= s <= 5
interval month(`precision`), 1 <= p <= 4	char(s char), 2 <= s <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6	char(s char), 3 <= s <= 12
interval year(`precision`) to month, 1 <= p <= 4	char(s char), 5 <= s <= 8
interval year(`precision`), 1 <= p <= 4	char(s char), 2 <= s <= 5
json	clob
mbr	blob
number(*,s), 0 <= s <= 37	char(255 char)
number(p,s), 1 <= p <= 38, 1 <= s <= 37	number(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37	number(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)	char(28 char)
period(time(`precision`) with time zone), 0 <= p <= 6	char(s char), 36 <= s <= 50
period(time(`precision`) ), 0 <= p <= 6	char(s char), 24 <= s <= 38
period(timestamp(`precision`) with time zone), 0 <= p <= 6	char(s char), 58 <= s <= 72
period(timestamp(`precision`) ), 0 <= p <= 6	char(s char), 46 <= s <= 60
smallint	number(5)
time(`precision`) with time zone, 0 <= p <= 6	timestamp(`precision`) with time zone, 0 <= p <= 6
time(`precision`), 0 <= p <= 6	timestamp(`precision`), 0 <= p <= 6
timestamp(0)	date
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp(`precision`) with time zone, 0 <= p <= 6
timestamp(`precision`), 1 <= p <= 6	timestamp(`precision`), 1 <= p <= 6
varbyte(`precision`), 1 <= p <= 64000	blob
varchar(`size`), 1 <= size <= 1501	char(s byte), 1 <= s <= 1501
varchar(`size`), 2001 <= size <= 64000	clob
varray	blob
xml	clob