| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Moving CLOB data from one db to another.
I am migrating data from one database[database1] to another[database2]. I
have a
link[dblink] between the two and one of the tables[CLOB_TABLE] have CLOB
datatype for one of their attributes[CLOB_BODY].
I need to cursor through this CLOB_TABLE and then insert the cursor variable
values into database2's table[CLOB_TABLE2].
I get the ORA-22992 error (cannot use LOB locators selected from remote
tables) when I run the script.
I tried the INSERT INTO CLOB_TABLE2 SELECT * FROM CLOB_TABLE_at_dblink; on
database1
directly but I still get the ORA-22992 error.
Does anyone have a method or code workaround of how to accomplish this?
thanks!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glenn Travis
INET: c-glenn.travis_at_wcom.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 30 2001 - 10:12:31 CDT
 |
 |