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 APRIL 17, 2023
Applies to:
Oracle SQL Developer - Version 18.3 to 18.3Information 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 |