CYBERTEC Migrator Documentation
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage Support

Supported Features

Database Object Types

CREATEComment
DATABASE LINKvisible, use PostgreSQL [Foreign Data Wrapper]
DIRECTORY
FUNCTIONcode needs to be translated manually
INDEX
MATERIALIZED VIEW
PACKAGEpackage code visible, code needs to be translated manually
PROCEDUREcode needs to be translated manually
SCHEMA
SEQUENCE
SYNONYMSvisible, have to be migrated manually
TABLEpartitions (hash, list, range) supported
TRIGGER
TYPE
USER
VIEW

Built-In Data Types

Detailed information about Oracle built-in data types may be found in the Oracle SQL Language Reference.

OracleDescriptionPostgreSQL
BFILEExternal LOBBYTEA (⏳ Coming soon)
BINARY_DOUBLE64-bit floating-point numberDOUBLE PRECISION
BINARY_FLOAT32-bit floating-point numberREAL
BLOBBinary large object, ⇐ 4G ⚠️BYTEA
CHAR(n), CHARACTER(n)Fixed-length string, 1 ⇐ n ⇐ 2000CHAR(n), CHARACTER(n)
CLOBCharacter large object, ⇐ 4G ⚠️TEXT
DATEDate and timeTIMESTAMP(0)
DECIMAL(p,s), DEC(p,s)Fixed-point numberDECIMAL(p,s), DEC(p,s)
DOUBLE PRECISIONFloating-point numberDOUBLE PRECISION
FLOAT(p)1 <= p < 24REAL
FLOAT(p)25 <= p < 53DOUBLE PRECISION
FLOAT(p)54 <= p <= 126 (p not provided)NUMERIC
INTEGER, INT38 digits integerDECIMAL(38)
INTERVAL DAY(p) TO SECOND(s)Day and time intervalINTERVAL DAY TO SECOND(s)
INTERVAL YEAR(p) TO MONTHDate intervalINTERVAL YEAR TO MONTH
LONGCharacter data, ⇐ 2G ⚠️TEXT
LONG RAWBinary data, ⇐ 2GBYTEA
NCHAR VARYING(n)Varying-length UTF-8 string, 1 ⇐ n ⇐ 4000VARCHAR(n) ⚠️
NCHAR(n)Fixed-length UTF-8 string, 1 ⇐ n ⇐ 2000CHAR(n) ⚠️
NCLOBVariable-length Unicode string, ⇐ 4G ⚠️TEXT
NUMBER(p,0), NUMBER(p)16-bit integer, 3 <= p < 5SMALLINT
NUMBER(p,0), NUMBER(p)32-bit integer, 5 <= p < 9INT
NUMBER(p,0), NUMBER(p)64-bit integer, 9 <= p < 19BIGINT
NUMBER(p,0), NUMBER(p)8-bit integer, 1 <= p < 3SMALLINT
NUMBER(p,0), NUMBER(p)Fixed-point number, 19 <= p <= 38DECIMAL(p)
NUMBER(p,s)Fixed-point number, s > 0DECIMAL(p,s)
NUMBER, NUMBER(*)Floating-point numberDOUBLE PRECISION
NUMERIC(p,s)Fixed-point numberNUMERIC(p,s)
NVARCHAR2(n)Varying-length UTF-8 string, 1 ⇐ n ⇐ 4000VARCHAR(n) ⚠️
RAW(n)Variable-length binary string, 1 ⇐ n ⇐ 2000BYTEA
REALFloating-point numberDOUBLE PRECISION
ROWIDPhysical row addressesCHAR(10) (⏳ Not automated yet)
SMALLINT38 digits integerDECIMAL(38)
TIMESTAMP(p)Date and time with fractionTIMESTAMP(p)
TIMESTAMP(p) WITH TIME ZONEDate and time with fraction and time zoneTIMESTAMP(p) WITH TIME ZONE
UROWID(n)Logical row addresses, 1 ⇐ n ⇐ 4000VARCHAR(n) (⏳ Not automated yet)
VARCHAR(n)Variable-length string, 1 ⇐ n ⇐ 4000VARCHAR(n)
VARCHAR2(n)Variable-length string, 1 ⇐ n ⇐ 4000VARCHAR(n)
XMLTYPEXML dataXML