GATHER_DATABASE_STATS ora 12754
- From: "David" <thump@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 28 Jun 2004 16:28:10 -0700 (PDT)
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
