目次

Search

  1. はじめに
  2. 一括取り込みデータベース

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

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

OracleソースとAmazon Redshiftターゲット

OracleソースとAmazon Redshiftターゲット

次の表は、OracleソースとAmazon Redshiftターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。
Oracleソースデータ型
Amazon Redshiftターゲットデータ型
binary_double
float8
binary_float
float4
blob
binary varying(1024000)
char(s byte), 1 <= size <= 2000
character varying(
size
), 4 <= size <= 2000
char(s char), 1 <= size <= 2000
character varying(
size
), 4 <= size <= 8000
clob
character varying(65535)
date
timestamp without time zone
float(
precision
), 1 <= p <= 126
character varying(255)
integer
character varying(255)
long raw
varbyte
long(2147483648 byte)
character varying(65535)
nchar(s char), 1 <= size <= 2000
character varying(
size
), 4 <= size <= 8000
nclob
character varying(65535)
number
number
number(*,s), -84 <= s <= 127
character varying(255)
number(38,s), 0 <= s <= 37
numeric(38,s), 0 <= s <= 37
number(p,s), 1 <= p <= 38, -37 <= s <= 37
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
number(p,s), 1 <= p <= 38, -84 <= s <= 127
character varying(
size
), 40 <= size <= 130
number(p,s), 10 <= p <= 38, -28 <= s <= 37
numeric(p,s), 10 <= p <= 38, 0 <= s <= 37
number(p,s), 11 <= p <= 38, -27 <= s <= 37
numeric(p,s), 11 <= p <= 38, 0 <= s <= 37
number(p,s), 12 <= p <= 38, -26 <= s <= 37
numeric(p,s), 12 <= p <= 38, 0 <= s <= 37
number(p,s), 13 <= p <= 38, -25 <= s <= 37
numeric(p,s), 13 <= p <= 38, 0 <= s <= 37
number(p,s), 14 <= p <= 38, -24 <= s <= 37
numeric(p,s), 14 <= p <= 38, 0 <= s <= 37
number(p,s), 15 <= p <= 38, -23 <= s <= 37
numeric(p,s), 15 <= p <= 38, 0 <= s <= 37
number(p,s), 16 <= p <= 38, -22 <= s <= 37
numeric(p,s), 16 <= p <= 38, 0 <= s <= 37
number(p,s), 17 <= p <= 38, -21 <= s <= 37
numeric(p,s), 17 <= p <= 38, 0 <= s <= 37
number(p,s), 18 <= p <= 38, -20 <= s <= 37
numeric(p,s), 18 <= p <= 38, 0 <= s <= 37
number(p,s), 19 <= p <= 38, -19 <= s <= 37
numeric(p,s), 20 <= p <= 38, 0 <= s <= 37
number(p,s), 2 <= p <= 38, -36 <= s <= 37
numeric(p,s), 2 <= p <= 38, 0 <= s <= 37
number(p,s), 21 <= p <= 38, -17 <= s <= 37
numeric(p,s), 21 <= p <= 38, 0 <= s <= 37
number(p,s), 22 <= p <= 38, -16 <= s <= 37
numeric(p,s), 22 <= p <= 38, 0 <= s <= 37
number(p,s), 23 <= p <= 38, -15 <= s <= 37
numeric(p,s), 23 <= p <= 38, 0 <= s <= 37
number(p,s), 24 <= p <= 38, -14 <= s <= 37
numeric(p,s), 24 <= p <= 38, 0 <= s <= 37
number(p,s), 25 <= p <= 38, -13 <= s <= 37
numeric(p,s), 25 <= p <= 38, 0 <= s <= 37
number(p,s), 26 <= p <= 38, -12 <= s <= 37
numeric(p,s), 26 <= p <= 38, 0 <= s <= 37
number(p,s), 27 <= p <= 38, -11 <= s <= 37
numeric(p,s), 27 <= p <= 38, 0 <= s <= 37
number(p,s), 28 <= p <= 38, -10 <= s <= 37
numeric(p,s), 28 <= p <= 38, 0 <= s <= 37
number(p,s), 29 <= p <= 38, -9 <= s <= 37
numeric(p,s), 29 <= p <= 38, 0 <= s <= 37
number(p,s), 3 <= p <= 38, -35 <= s <= 37
numeric(p,s), 3 <= p <= 38, 0 <= s <= 37
number(p,s), 30 <= p <= 38, -8 <= s <= 37
numeric(p,s), 30 <= p <= 38, 0 <= s <= 37
number(p,s), 31 <= p <= 38, -7 <= s <= 37
numeric(p,s), 31 <= p <= 38, 0 <= s <= 37
number(p,s), 32 <= p <= 38, -6 <= s <= 37
numeric(p,s), 32 <= p <= 38, 0 <= s <= 37
number(p,s), 33 <= p <= 38, -5 <= s <= 37
numeric(p,s), 33 <= p <= 38, 0 <= s <= 37
number(p,s), 34 <= p <= 38, -4 <= s <= 37
numeric(p,s), 34 <= p <= 38, 0 <= s <= 37
number(p,s), 35 <= p <= 38, -3 <= s <= 37
numeric(p,s), 35 <= p <= 38, 0 <= s <= 37
number(p,s), 36 <= p <= 38, -2 <= s <= 37
numeric(p,s), 36 <= p <= 38, 0 <= s <= 37
number(p,s), 37 <= p <= 38, -1 <= s <= 37
numeric(p,s), 37 <= p <= 38, 0 <= s <= 37
number(p,s), 4 <= p <= 38, -34 <= s <= 37
numeric(p,s), 4 <= p <= 38, 0 <= s <= 37
number(p,s), 5 <= p <= 38, -33 <= s <= 37
numeric(p,s), 5 <= p <= 38, 0 <= s <= 37
number(p,s), 6 <= p <= 38, -32 <= s <= 37
numeric(p,s), 6 <= p <= 38, 0 <= s <= 37
number(p,s), 7 <= p <= 38, -31 <= s <= 37
numeric(p,s), 7 <= p <= 38, 0 <= s <= 37
number(p,s), 8 <= p <= 38, -30 <= s <= 37
numeric(p,s), 8 <= p <= 38, 0 <= s <= 37
number(p,s), 9 <= p <= 38, -29 <= s <= 37
numeric(p,s), 9 <= p <= 38, 0 <= s <= 37
nvarchar2(s char), 1 <= size <= 4000
character varying(
size
), 4 <= size <= 16000
raw(
size
), 1 <= size <= 2000
varbyte
rowid
character varying(18)
timestamp(
precision
) with time zone, 0 <= p <= 6
timestamp with time zone
timestamp(
precision
) with time zone, 7 <= p <= 9
character varying(29)
timestamp(
precision
), 1 <= p <= 6
timestamp without time zone
timestamp(
precision
), 7 <= p <= 9
character varying(
size
), 27 <= s <= 29
varchar2(s byte), 1 <= size <= 4000
character varying(
size
), 4 <= size <= 4000
varchar2(s char), 1 <= size <= 4000
character varying(
size
), 4 <= size <= 16000
LOBの制限事項
データベース取り込み初期ロードジョブで、Oracle BLOB、CLOB、およびNCLOBカラムからAmazon Redshiftターゲットにデータをレプリケートできます。LOBカラムデータは、ターゲットに書き込まれる前に切り詰められる場合があります。切り詰めポイントは、データ型とターゲットタイプによって異なります。Amazon Redshiftターゲットを使用した初期ロードジョブの場合、BLOBデータは1024000バイトに切り詰められ、CLOBおよびNCLOBデータは65535バイトに切り詰められます。詳細については、ソースの設定の[LOBを含める]に関する説明を参照してください。
サポートされていないソースデータ型
一括取り込みデータベース
では、次のOracleソースデータ型はサポートされません。
  • ANYTYPE、ANYDATA、ANYDATASETなどの「ANYタイプ」
  • 拡張タイプ
  • INTERVAL
  • JSON
  • LOB(初期ロードジョブのBLOB、CLOB、およびNCLOBを除く)
  • TIMESTAMP WITH LOCAL TIME ZONE
  • UROWID
  • XMLTYPE、URIタイプ、URIFactoryパッケージのサブタイプなどのXML定義タイプ
  • SDO_GEOMETRYなどの空間タイプ
  • OBJECT、REF、VARRAY、ネストされたテーブルタイプなどのユーザー定義タイプ
サポートされていないデータ型を持つソースカラムは、ターゲット定義から除外されます。