SQL & PL/SQL

Hi,

I have a problem to import BLOB field.

I have a DBLINK with a SQLSERVER database with a table with pictures in a field.
I need to import in my Oracle DB 12c this pictures. How can I do?

I tried with:

CREATE TABLE myTab AS SELECT * FROM tb1@dblink;

This is the error:

Errore SQL: ORA-00997: Uso non consentito del tipo dati LONG
00997. 00000 -  "illegal use of LONG datatype"
*Cause:   
*Action:

CREATE TABLE tblob ( f1 BLOB);
INSERT INTO tblob (SELECT TO_LOB(field1) FROM tb1@dblink);

Report errori -
Errore SQL: ORA-00997: Uso non consentito del tipo dati LONG
00997. 00000 -  "illegal use of LONG datatype"
*Cause:   
*Action:

CREATE TABLE tCLOB (f1 CLOB);
INSERT INTO tclob (SELECT TO_LOB(field1) FROM tb1@dblink);

Report errori -
Errore SQL: ORA-00932: tipi di dati incoerenti: previsto CLOB, ottenuto BLOB
00932. 00000 -  "inconsistent datatypes: expected %s got %s"
*Cause:   
*Action:

Who can help me?
Thanks
Manu