create table ..as select over dblink hangs with the wait event "sql*net more data from dblink"
The query select COUNT(*) from vw_move2_nl@link_ibis_loader takes 0.2 sec. The statement create table test as select * from vw_move2_nl@link_ibis_loader WHERE 1=2 hangs.SQL> set autotrace on statistics
SQL> select COUNT(*) from vw_move2_nl@link_ibis_loader;
COUNT(*)
----------
49
Statistiken
----------------------------------------------------------
1 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
350 bytes sent via SQL*Net to client
435 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> create table test as select * from vw_move2_nl@link_ibis_loader WHERE 1=2;
The same problem I have with the direkt load insert into table over dblink. Coventional insert runs immediately, but the same insert with hint /*+ append */ hangs,
SQL> select COUNT(*) from vw_move2_nl@link_ibis_loader;
COUNT(*)
----------
49
Statistiken
----------------------------------------------------------
1 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
350 bytes sent via SQL*Net to client
435 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
SQL> create table test as select * from vw_move2_nl@link_ibis_loader WHERE 1=2;
The same problem I have with the direkt load insert into table over dblink. Coventional insert runs immediately, but the same insert with hint /*+ append */ hangs,
0