SQL> show user
USER is "WMOS_ARCHB"

SQL> Begin
2 For tableList In (Select Owner, Table_Name From All_Tables
3 Where Owner IN(('WMOS_ARCHB'))
4 and temporary = 'N'
5 Order By Owner, Table_Name)
6 Loop
7 dbms_stats.gather_table_stats(tableList.Owner,
8 tableList.Table_Name,
9 estimate_percent=>100,
10 method_opt => 'for all columns size auto',
11 cascade => true);
End Loop;
12 13 End;
14 /
Begin
*
ERROR at line 1:
ORA-20001: DATASOURCE_SQL_REM CONNECTION is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 18408
ORA-06512: at "SYS.DBMS_STATS", line 18429
ORA-06512: at line 7