My Oracle Support Banner

Online Migration using Oracle Sql Develper V18. failed with ORA-22922: nonexistent LOB value (Doc ID 2490233.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle SQL Developer - Version 18.3 to 18.3
Information in this document applies to any platform.


You are using Oracle SQL Developer V18. and your Online Migration of MySQL failed with error ORA-22922: nonexistent LOB value.

2018-12-14T14:03:55 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle WARNING oracle.dbtools.migration.workbench.core.ui.FullMigrateTask Error during capture: ORA-22922: nonexistent LOB value Capture.EXCEPTION oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle ORA-22922: nonexistent LOB value oracle.dbtools.migration.workbench.core.logging.LogInfo@21a86c5f 2018-12-14T14:03:55 oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle SEVERE oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil Capture Classic Capture ORA-22922: nonexistent LOB value oracle.dbtools.metadata.persistence.PersistableObject.doInsert( oracle.dbtools.migration.workbench.core.BasicMigrationStorer.storeObject( oracle.dbtools.migration.workbench.mysql3.MySQLCapturer.captureColumnPrivilege( oracle.dbtools.migration.workbench.mysql5.MySQL5Capturer.captureColumnDetails(

With old version Oracle SQL Developer, V2.1.1.64, this migration was successful.


SQL Developer version changed.

Moved from SQL Developer V2.1.1.64 to SQL Developer V18.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.