ORA-00997: illegal use of LONG datatype が発生してデータ移行ができない原因と対処について

SQL> conn scott/tiger
Connected.

SQL> create table long_test(c1 number(4), c2_long long raw);
Table created.

SQL> insert into long_test values(1,'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
1 row created.
SQL> select * from long_test;
        C1 C
---------- -
         1 0

SQL> create database link src connect to scott identified by tiger using 'src';
Database link created.

SQL> select * from long_test@src;
        C1 C
---------- -
         1 0

SQL> create table long_test_copy (c1 number(4), c2_long long raw);
Table created.

SQL> insert into long_test_copy select * from long_test@src;
insert into long_test_copy select * from long_test@src
                                  *
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

SQL> host expdp scott/tiger directory=dumpdir tables=long_test;
Export: Release 11.2.0.4.0 - Production on Tue Jul 20 12:19:57 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=dumpdir tables=long_test
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."LONG_TEST"                         5.468 KB       1 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  /u01/app/hellomyworld/dumpdir/expdat.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Tue Jul 20 12:20:03 2021 elapsed 0 00:00:05
                                                                100%   96KB  21.6MB/s   00:00

[hellomyworld@myhost dumpdir]$ scp expdat.dmp oracle@XXX.XX.XXX.XXX:/u01/app/oracle/dumpdir
The authenticity of host 'XXX.XX.XXX.XXX (XXX.XX.XXX.XXX)' can't be established.
ECDSA key fingerprint is XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
ECDSA key fingerprint is XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'XXX.XX.XXX.XXX' (ECDSA) to the list of known hosts.
oracle@XXX.XX.XXX.XXX's password:
expdat.dmp

SQL> conn testuser/test
Connected.

SQL> host impdp testuser/test directory=dumpdir dumpfile=expdat.dmp;
Import: Release 19.0.0.0.0 - Production on Tue Jul 20 11:32:55 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "TESTUSER"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TESTUSER"."SYS_IMPORT_FULL_01":  testuser/******** directory=dumpdir dumpfile=expdat.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."LONG_TEST"                         5.468 KB       1 rows
Job "TESTUSER"."SYS_IMPORT_FULL_01" successfully completed at Tue Jul 20 11:33:05 2021 elapsed 0 00:00:09

SQL> conn scott/tiger
Connected.

SQL> select * from long_test;
        C1 C
---------- -
         1 0

SQL> create table lob_test (c1 number(4),　c2_lob clob);
Table created.

SQL> insert into lob_test select c1, to_lob(c2_long) from long_test;
commit;

SQL> select * From lob_test;

        C1 C
---------- -
         1 0

SQL> create table lob_test_2 (c1 number(4), c2_lob clob);
Table created.

SQL> insert into lob_test_2 select * from lob_test@src;
1 row created.

SQL> select * From lob_test_2;

        C1 C
---------- -
         1 0