Migrate from Oracle to MatrixOne

Pin Oracle/MO/exporter versions and review objects plus actual ranges. Oracle was not connected in this review; these are mapping decisions with MO v4.2.5 target boundary experiments.

Types and objects

Oracle

Candidate/policy

Retain or verify

NUMBER(5,0) / NUMBER(10,0)

DECIMAL(5,0)/DECIMAL(10,0), or range-verified integers

SMALLINT/INT do not cover 99999/9999999999

NUMBER(38,0)

DECIMAL(38,0)

All 38 digits; not BIGINT or misspelled bitint

NUMBER(p,s) / unspecified precision

Distribution-based DECIMAL precision/scale

Negative scale, rounding, overflow, unconstrained declaration

VARCHAR2 / NVARCHAR2 / CLOB

VARCHAR/TEXT by size/query needs

Character/byte length, Unicode, empty strings becoming NULL

DATE / TIMESTAMP

DATETIME plus original-value retention

DATE includes time; retain precision beyond microseconds

TIMESTAMP WITH TIME ZONE / LOCAL TIME ZONE

Normalized instant plus original timezone/offset/text

Original zones and session conversions

RAW / LONG RAW / BLOB

VARBINARY/BLOB

Original bytes and zero bytes

Spatial

WKT/WKB + SRID; verify functions

CRS, axes, units, planar/geodesic semantics

BFILE / ROWID / UDT / XML

Dedicated representations/business alternatives

External files, identity stability, methods; no automatic-conversion claim

Sequences, triggers, PL/SQL/packages, synonyms, materialized views, privileges, and schema naming require separate designs. MySQL-shaped output does not establish Oracle business equivalence.

Copy and accept

Select exporters, DBeaver, or verified batch readers/writers. Trial isolated schemas/targets and review DDL object by object. Do not delete CHECK/unique indexes or globally replace NUMBER. With ongoing writes, bind consistency to SCN/log capture and test inserts/updates/deletes/recovery; otherwise arrange write suspension.

Match file columns, encoding, NULLs, quotes/escapes, and date formats. Benchmark batch memory/bytes/load: 5000 rows does not guarantee direct S3 writes. Validate keys, exact values, time, replacement constraints, and real business queries, not just counts.

See executable heterogeneous boundary checks and migration phases. Oracle source, SCN handoff, and production cutover remain unverified.