Hi,
I'm trying to move over a remote table to the server I'm working on by 'DATABASE LINK' and 'SELECT FROM'.
However, the remote table contains a BLOB column and it gives the following error:
'ORA-22992: cannot use LOB locators selected from remote tables'.
How can I convert the BLOB field to VARCHAR2 so that I can move over the table and/or SELECT FROM that table from remote server?
Thank you.
You can use the sqlplus COPY command to copy the table locally:
http://docs.oracle.com/cd/E11882_01/server.112/e16604/apb.htm#i641251
As far as converting it to a varcahr2, that would need to be done on the remote server and will limit you to 4000 characters. Also, BLOBs are typically used for Binary data. A UTL_RAW.CONVERT_TO_VARCHAR