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.