Hello friends I have a detail when creating a view in oracle because I use the ROW_NUMBER to count the elements of my query, however when creating the view I get the following error

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

The query I run is as follows

SELECT TEMPLATE.TEMPLATE_DOCUMENT_ID AS ID_TEMPLATE,ROW_NUMBER() OVER (Partition By SIGNERS.DOCUMENT_TEMPLATE_ID Order By SIGNERS.DOCUMENT_TEMPLATE_ID DESC )  AS ID_SIGN

FROM [email protected]  TEMPLATE 
INNER JOIN [email protected] DOMAIN 
ON TEMPLATE.TEMPLATE_DOCUMENT_ID = DOMAIN.DOCUMENT_TEMPLATE_ID
INNER JOIN [email protected]  SIGNERS
ON DOMAIN.DOCUMENT_TEMPLATE_ID = SIGNERS.DOCUMENT_TEMPLATE_ID

AND TEMPLATE.ESTATUS = 1;

I am making a view with a dblink to be able to access some data and tables that correspond to another bd, the SIGNERS table has a column of type lob.

Is there any way to solve this issue since I am not querying the column of this type in the over partition ?

the results I get from my query are currently correct