# Migrate Oracle table with LOB column **URL:** \ **Category:** General\ **Created:** [April 8, 2025, 3:21pm UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340 "2025-04-08T15:21:31Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![siddiqui](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@siddiqui](https://forum.yugabyte.com/u/siddiqui)\ **Post date:** [April 8, 2025, 3:21pm UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/1 "2025-04-08T15:21:32Z")
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 ? ---
**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\ **Post date:** [April 9, 2025, 6:18am UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/2 "2025-04-09T06:18:36Z")
Hi @siddiqui yb-voyager is recommended for migrating [Migrate to YugabyteDB using Voyager | YugabyteDB Docs](https://docs.yugabyte.com/preview/yugabyte-voyager/) 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](https://github.com/yugabyte/yugabyte-db/issues/3576) ---
**Author:** ![siddiqui](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@siddiqui](https://forum.yugabyte.com/u/siddiqui)\ **Post date:** [April 10, 2025, 3:29pm UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/3 "2025-04-10T15:29:25Z")
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? ---
**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\ **Post date:** [April 11, 2025, 7:33am UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/4 "2025-04-11T07:33:04Z")
> [@siddiqui](#): > > CLOB size is 45gb. I meant the size of a single column in a single row. Do you really have a single column value that is 45GB? ---
**Author:** ![siddiqui](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@siddiqui](https://forum.yugabyte.com/u/siddiqui)\ **Post date:** [April 14, 2025, 6:21pm UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/5 "2025-04-14T18:21:53Z")
45gb is overall CLOB size for this table. single column size for CLOB is not crossing more than 2MB. ---
**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\ **Post date:** [April 15, 2025, 12:14pm UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/6 "2025-04-15T12:14:59Z")
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? ---
**Author:** ![siddiqui](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@siddiqui](https://forum.yugabyte.com/u/siddiqui)\ **Post date:** [April 16, 2025, 3:48am UTC](https://forum.yugabyte.com/t/migrate-oracle-table-with-lob-column/4340/7 "2025-04-16T03:48:49Z")
thanks Dorian, i am looking for some direct way to handle these data type, as there are other tables too.