Migrate Oracle table with LOB column

General
1

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 ?

2

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

3

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?

4

I meant the size of a single column in a single row. Do you really have a single column value that is 45GB?

5

45gb is overall CLOB size for this table. single column size for CLOB is not crossing more than 2MB.

6

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?

7

thanks Dorian, i am looking for some direct way to handle these data type, as there are other tables too.