Hello,
I am inserting data in several tables with CLOB column.
The source database is an exadata 12.2 and target (aws machine) also is
12.2 Oracle version.
The source database has NLS_CHARACTERSET WE8ISO8859P1 and the target
database has : WE8MSWIN1252.
I got success with 2 tables and I got this error : "ORA-22922 nonexistent
LOB value" with another table.
I am using python language to insert with cx_Oracle. The insert command
uses data as bind variable. I saw in the gv$sqlarea.
Before insert I remove all data. The table is empty. And tried to use :
TRUNCATE and DELETE
I read in the Oracle documentation the following:
Quote
Cause: The LOB value associated with the input locator does not exist.
The information in the locator does not refer to an existing LOB.
Action: Repopulate the locator by issuing a SELECT statement and retry the
operation.
End Quote
How to fix it ? How to repopulate the locator ?
Any experience with this error ?
Regards
Eriovaldo