My Oracle Support Banner

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

Last updated on SEPTEMBER 05, 2019

Applies to:

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

Symptoms

You are using Oracle SQL Developer V18.3.0.277.2354 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(PersistableObject.java:248) oracle.dbtools.metadata.persistence.PersistableObject.save(PersistableObject.java:182) oracle.dbtools.migration.workbench.core.BasicMigrationStorer.storeObject(BasicMigrationStorer.java:51) oracle.dbtools.migration.workbench.mysql3.MySQLCapturer.captureColumnPrivilege(MySQLCapturer.java:655) oracle.dbtools.migration.workbench.mysql5.MySQL5Capturer.captureColumnDetails(MySQL5Capturer.java:499)


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

Changes

SQL Developer version changed.

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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