ORA-22992: cannot use LOB locators selected from remote tables

Hi Friends,

I am trying to create a view in my local database for a table in the remote database using DBLINK.

Below is the SQL Statement,

CREATE VIEW ABC AS SELECT * FROM Rockstar.Table1@MYDBLINK;

                                        

I am getting the below error.

ERROR at line 1:

ORA-22992: cannot use LOB locators selected from remote tables

Upon checking the Description of Table 1, Table 1 has a column which is of the Data Type CLOB.

How can I resolve this issue? Please help.

Thanks,

Su.