Best Wallpaper Ideas website. Search anything about Wallpaper Ideas in this website.

Ora22992. Insert into t2 select from t1. Cannot use LOB locators selected from remote tables.

Pin On Dresses
Pin On Dresses from www.pinterest.com

Is there any workaround for that. I think the first command is rather INSERT. 11 From the remote database.

ORACLE - Query remote LOB data ORA-22992.

Cannot use LOB locators selected from remote tables Solution In DB1 create global temporary table with the same structure as test table lets name it as testglobal. A remote LOB column cannot be referenced. There is problem with creation of materialized view with clob and xmltype columns till 11203. Or same as below create a function procedure to convert the lob to string.