It has a very simple way to do this, it matters all other tables and leaves this out because there are lob fields, you create a dblink with a qualifying name in the bank where you generated the export:
Select all
CREATE DATABASE LINK cent.word
CONNECT TO system IDENTIFIED BY homo234
USING 'homoint'
Select all
create table tabela6 as select * from tabela6@cent.word
- Cent.Word (may be the name you want)
- System User connected in the bank you want to bring the table with lob, can be another user
- homo234 is the same password of the user's user of the bank from which you want to bring the lob
- TAB_TESTE_DBLINK2 is the table of Banco Homoint where it has a CLOB field
- Homoint (bank from which we want the table with the LOB field, must be in tnsnames.ora, test using tnsping for example: Tnping Homoint);
- table which was created through another remote table of a dblink, where it is already with the LOB field
99]
Note: This was beautiful: D