Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Oracle Source and Oracle Target

Oracle Source and Oracle Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with an Oracle source and an Oracle target:
Oracle Source Data Type
Oracle Target Data Type
binary_double
binary_double
binary_float
binary_float
blob
blob
char(s byte), 1 <= s <= 2000
char(s byte), 1 <= s <= 2000
char(s char), 1 <= s <= 2000
char(s char), 1 <= s <= 2000
clob
clob
date
date
float(
precision
), 1 <= p <= 126
float(
precision
), 1 <= p <= 126
integer
integer
long raw
long raw
long(2147483648 byte)
long(2147483648 byte)
nchar(s char), 1 <= s <= 2000
nchar(s char), 1 <= s <= 2000
nclob
nclob
number
number
number(*,s), -84 <= s <= 127
number(*,s), -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
number(p,s), 1 <= p <= 38, -84 <= s <= 127
nvarchar2(s char), 1 <= s <= 4000
nvarchar2(s char), 1 <= s <= 4000
raw(
size
), 1 <= s <= 4000
raw(
size
), 1 <= s <= 4000
rowid
rowid
timestamp(
precision
) with time zone, 0 <= p <= 9
timestamp(
precision
) with time zone, 0 <= p <= 9
timestamp(
precision
), 1 <= p <= 9
timestamp(
precision
), 1 <= p <= 9
varchar2(s byte), 1 <= s <= 4000
varchar2(s byte), 1 <= s <= 4000
varchar2(s char), 1 <= s <= 4000
varchar2(s char), 1 <= s <= 4000

0 COMMENTS

We’d like to hear from you!