Why not snapshot the table with the CLOB which works. Do you need real-time selects against a table with a CLOB across a database link?

Ian MacGregor
Stanford Linar Accelerator Center
[Email address protected]



-----Original Message-----
From: Uday K. R [mailto:oracledba-ezmlmshield-x92387591.[Email address protected]
Sent: Wednesday, June 02, 2004 2:37 PM
To: LazyDBA.com Discussion
Subject: cannot acces LOB using dblinks

Hi All

I have a table in remote database which is having LOB field I have created a dblink and issued a select statement that gives me a error

how do we access a lob column using dblink in 9i

Uday


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page