Problem solve Get help with specific problems with your technologies, process and projects.

Export/import on table with clob datatype column

How to export and import a table that has a clob datatype column? I am getting errors during export and import.

How to export and import a table that has a clob datatype column? I am getting the following errors during export and import:
. . exporting table                    V_VWORKFLOW
EXP-00056: ORACLE error 24801 encountered
ORA-24801: illegal parameter value in OCI lob function


. . importing table                  "V_VWORKFLOW"
IMP-00009: abnormal end of export file
IMP-00064: Definition of LOB was truncated by export
IMP-00028: partial import of previous table rolled back: 
11 rows rolled back Import terminated successfully with warnings.
You are probably getting this error due to differences in your Oracle versions. As a good rule of thumb, use the lower version of export to create the dump file. Then use the destination version of imp for the import process. For instance, if I am copying data from a 10g database to an Oracle 8i database, I use the 8i export utility and the 8i import utility. If I am copying data from a 9i database to a 10g database, I use the 9i export utility and the 10g import utility.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.