Skip to main content
Version: 1.6

Oracle RMAN backup sets → Parquet

Datatypes conversion mapping when exporting a table from Oracle RMAN backup sets (full and incremental) using the ArpeOraBackup ADBC driver (--connectiontype backup_rman) to Parquet format.

Platform availability

backup_rman is available on Windows x64 and Linux x64 only. It is not supported on Linux ARM64.

Compared with adbc_oracle

For the types both connectors read, the mapping is the one of adbc_oracle, with the same values.

SourceOracle RMAN backup sets (backup_rman)
FormatParquet
FastBCP1.6.4.0
Test StatusOK (16/16 Nullable) — Oracle 19c, 23ai and 26ai backups, every compression

Parquet Schema​

Oracle typephysical_typeconverted_typelogical_type
NUMBER(10)INT64——
NUMBERBYTE_ARRAYUTF8StringType()
FLOATBYTE_ARRAYUTF8StringType()
NUMBER(18)INT64——
NUMBER(12,4)FIXED_LEN_BYTE_ARRAYDECIMALDecimalType(scale=4, precision=12)
NUMBER(38)FIXED_LEN_BYTE_ARRAYDECIMALDecimalType(scale=0, precision=38)
VARCHAR2(200)BYTE_ARRAYUTF8StringType()
CHAR(10)BYTE_ARRAYUTF8StringType()
NVARCHAR2(100)BYTE_ARRAYUTF8StringType()
NCHAR(5)BYTE_ARRAYUTF8StringType()
BINARY_FLOATFLOAT——
BINARY_DOUBLEDOUBLE——
DATEINT64TIMESTAMP_MILLISTimestampType(isAdjustedToUTC=0, unit=MILLIS)
TIMESTAMP(0)INT64TIMESTAMP_MILLISTimestampType(isAdjustedToUTC=0, unit=MILLIS)
TIMESTAMP(6)INT64TIMESTAMP_MICROSTimestampType(isAdjustedToUTC=0, unit=MICROS)
TIMESTAMP(9)INT64—TimestampType(isAdjustedToUTC=0, unit=NANOS)
TIMESTAMP(6) WITH TIME ZONEINT64TIMESTAMP_MICROSTimestampType(isAdjustedToUTC=1, unit=MICROS)
TIMESTAMP(6) WITH LOCAL TIME ZONEINT64TIMESTAMP_MICROSTimestampType(isAdjustedToUTC=1, unit=MICROS)
RAW(100)BYTE_ARRAY——
LONGBYTE_ARRAYUTF8StringType()
LONG RAWBYTE_ARRAY——
Refused columns

LOB (CLOB, NCLOB, BLOB, BFILE), INTERVAL, ROWID / UROWID, JSON, VECTOR, XMLTYPE and object columns cannot be exported: a table with such a column is refused with a message naming the column. Export the other columns by listing them in --query.

Copyright © 2026 Architecture & Performance.