what is best way to migrate oracle table that have LOBs to yugabyte. oracle table size is 500gb?
we have same table dumped in AVRO format, Is there any way we can load avro files to yugabyte ?
Hi @siddiqui
yb-voyager is recommended for migrating Migrate to YugabyteDB using Voyager | YugabyteDB Docs
We currently don’t support avro files but yb-voyager should help with the whole migration process.
Regarding the LOB column, what is the size of the values? We currently don’t support LOBs, but you can use a general BLOB with row sizes growing up to 64MB [YSQL] BLOB support · Issue #3576 · yugabyte/yugabyte-db · GitHub
Hi dorian,
thanks for update.
CLOB size is 45gb.
with yb-voyager , it skips that column.
do we have any other format supported for yb-voyager apart from CSV?
I meant the size of a single column in a single row. Do you really have a single column value that is 45GB?
45gb is overall CLOB size for this table. single column size for CLOB is not crossing more than 2MB.
Hi @siddiqui
There’s no workaround currently in yb-voyager to support lob
columns.
Can you export the lob
columns as blob/bytea
and import them into yugabyte?
thanks Dorian, i am looking for some direct way to handle these data type, as there are other tables too.