0
I tried to use TO_LOB to convert the value LONG RAW in the insert but returns:
ORA-00932 inconsistent datatypes tips
Fate is a column BLOB of a table already in use of the system and its type cannot be changed with ALTER MODIFY, the solution was to create a NOVA intermediate table with the type column BLOB to be converted and only after the INSERT in the Final Table with the same column types(BLOB).
Returns error? you may also try to convert the column into the table itself (https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_long_lob.htm#i1006316)
– Gustavo Fast
ORA-00932 inconsistent datatypes tips, I can’t change the original table is a migration, and I can’t change the destination because it already has other data.
– Andrey Hideki Nakano
You can send the sentence?
– Gustavo Fast
I decided to create a temporary intermediate table with the column of type BLOB and then import in the table Destination.
– Andrey Hideki Nakano
@Andreyhideki, can you add an answer to how the table looked? So if someone goes through the problem,
– David