Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22992 Error
ORA-22992 Error [message #248838] Mon, 02 July 2007 05:15 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi

I have created a database link to access remote table which has a CLOB column

When i try to query the data it says

ORA-22992 Cannot use LOB Locators used from remote tables

But i need to insert this data from remote table to a local table.

Please suggest me how can i acheive this.

Thanks in advacne.
Re: ORA-22992 Error [message #250673 is a reply to message #248838] Tue, 10 July 2007 15:24 Go to previous messageGo to next message
toyway
Messages: 32
Registered: July 2002
Member
Check out this URL:
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96591/adl04mng.htm#98328

HTH,
Oleg
Re: ORA-22992 Error [message #250674 is a reply to message #248838] Tue, 10 July 2007 15:27 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>But i need to insert this data from remote table to a local table.
Don't pull the data to you, push it from the source database to the target database.
Previous Topic: CASE not working
Next Topic: Simple way of doing spooling within spooling?
Goto Forum:
  


Current Time: Sat Dec 03 09:41:09 CST 2016

Total time taken to generate the page: 0.05486 seconds