GATHER_DATABASE_STATS ora 12754

From: David <thump_at_cosmiccooler.org>
Date: Mon, 28 Jun 2004 16:28:10 -0700 (PDT)
Message-ID: <3805.64.37.153.21.1088465290.squirrel@www.cosmiccooler.org>

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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Jun 28 2004 - 18:24:54 CDT