GATHER_DATABASE_STATS ora 12754

Any ideas on what could cause this:

exec DBMS_STATS.GATHER_DATABASE_STATS( -
   estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -
   block_sample     => TRUE, -
   method_opt       => 'FOR ALL COLUMNS SIZE SKEWONLY', -
   degree           => 4, -
   granularity      => 'DEFAULT',  -
   cascade          => TRUE, -
   stattab          => NULL,  -
   statid           => NULL, -
   options          => 'GATHER', -
   statown          => NULL, -
   gather_sys       => FALSE, -
   no_invalidate    => FALSE, -
   gather_temp      => FALSE);

SQL> @gather_db_stats.sql
BEGIN DBMS_STATS.GATHER_DATABASE_STATS(     estimate_percent =>
DBMS_STATS.AUTO_SAMPLE_SIZE,     block_sample     => TRUE,     method_opt 
     => 'FOR ALL COLUMNS SIZE SKEWONLY',     degree           => 4,    
granularity      => 'DEFAULT',      cascade          => TRUE,     stattab 
        => NULL,      statid           => NULL,     options          =>
'GATHER',     statown          => NULL,     gather_sys       => FALSE,    
no_invalidate    => FALSE,     gather_temp      => FALSE); END;

*
ERROR at line 1:
ORA-12714: invalid national character set specified
ORA-06512: at "SYS.DBMS_STATS", line 9375
ORA-06512: at "SYS.DBMS_STATS", line 9857
ORA-06512: at "SYS.DBMS_STATS", line 10041
ORA-06512: at "SYS.DBMS_STATS", line 10134
ORA-06512: at "SYS.DBMS_STATS", line 10114
ORA-06512: at line 1

Elapsed: 00:17:59.30

As you can see, this runs for nearly 20 minutes and then fails.
- David Green
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: