Support Coverage and Specifications

Check the support scope and details of the migration features provided by OwlDB.

Supported databases

Source database	Target database
Oracle 11g, 12c, 18c, 19c	Tibero 7

Note

Currently only CDB migrations are supported, PDB migrations will be supported in the future.

Supported objects

OwlDB migration migrates all Independent Objects and Dependent Objects at once. It does not support selectively pulling down or excluding only IndependentObjects.

Oracle	Tibero	Note
Constraint	Constraint	Supports migration for primary key, foreign key, check, and ref constraints. Primary key index/constraint are all treated as constraints Check constraint's expression uses sentences stored in Oracle's DD to generate DDL
Index	Index	R-TREE not supported Domain Index not supported
Materialized	Materialized	-
Materialized View Log	Materialized View Log	-
Privilege	Privilege	-
PSM	PSM	-
Role	Role	-
Schema	Schema	-
Sequence	Sequence	-
Synonym	Synonym	-
Table	Table	Nested Table not supported XML Table not supported
Tablespace	Tablespace	Increase the size of the tablespace by 20% -> Data migration may result in larger capacity than in TO-BE.
View	View	-

Data Conversion Types

This section describes the data types that are converted when migrating from Oracle to Tibero.

Oracle	Tibero
blob	BLOB
binary_float	BINARY_FLOAT
binary_double	BINARY_DOUBLE
character	CHAR
clob	CLOB
date	DATE
interval day to second	INTERVAL DAY(2) TO SECOND(6)
interval year to month	INTERVAL YEAR(2) TO MONTH
long	LONG
long raw	LONG RAW
nchar	NCHAR
nclob	NCLOB
number	NUMBER
nvarchar2	NVARCHAR2
rowid	ROWID
time	TIME
timestamp	TIMESTAMP
timestamp with time zone	TIMESTAMP WITH TIME ZONE
timestamp with local time zone	TIMESTAMP(6) WITH LOCAL TIME ZONE
varchar	VARCHAR
varchar2	VARCHAR2
xmltype	XMLTYPE