Ok, another problem.
When I try DBMS_STATS.EXPORT_SCHEMA_STATS I now get this


SQL> BEGIN SYS.DBMS_STATS.EXPORT_SCHEMA_STATS (OWNNAME=>'MYNAME', STATTAB=>'MYNAME_STATS_TABLE', STATID=>'PRE_8416_PATCH'); END;

*
ERROR at line 1:
ORA-20000: Schema MYNAME does not exist or insufficient privileges to analyze
an object within it
ORA-06512: at "SYS.DBMS_STATS", line 3028
ORA-06512: at "SYS.DBMS_STATS", line 3050
ORA-06512: at "SYS.DBMS_STATS", line 3326
ORA-06512: at line 1

I have tried running this as users internal, sys, system and myname but all get the same error. MYNAME schema does exist, but I'm not sure what privilege problem I might be having.