ORA-22992 Cannot use LOB Locators used from remote tables
While executing a Stored proc, we got the error:ORA-22992 Cannot use LOB Locators used from remote tables .
From OTN i learnt that you can't select LOBs from a remote table using DB links. So i suggested to create a view on the table which has the LOB field and use this view in the query rather than the table.
Onsite DBA created a materialised view on this table and everything is working fine. But, isn't a normal VIEW (not a Materialized view) enough for this purpose considering the space overhead ?