I am getting SOrt key too long error error while executing the dbms_stat pack .

[Kevin Golding via DBMonster.com]

Hi,

I am trying to analyze the 'SBM' schema in the database on SOLARIS 2.9 with
ORACLE 8.1.7.3. The command I am using to analyze the schema is
exec dbms_stats.gather_schema_stats (ownname => 'SBM', estimate_percent =>
5, cascade => true, options => 'GATHER');

But after issuing this command I am getting the following error:

SQL> exec dbms_stats.gather_schema_stats (ownname => 'SBM',
estimate_percent => 5, cascade => true, options => 'GATHER');
BEGIN dbms_stats.gather_schema_stats (ownname => 'SBM', estimate_percent =>
5, cascade => true, options => 'GATHER'); END;

*
ERROR at line 1:
ORA-01467: sort key too long
ORA-06512: at "SYS.DBMS_STATS", line 4481
ORA-06512: at "SYS.DBMS_STATS", line 4612
ORA-06512: at "SYS.DBMS_STATS", line 4722
ORA-06512: at "SYS.DBMS_STATS", line 4704
ORA-06512: at line 1

Thanks in advance for help.

Regards,
Salil

--
Message posted via http://www.dbmonster.com

[Jerome]

On Thu, 14 Apr 2005 05:19:52 +0000, Salil Sanghvi via DBMonster.com wrote:
ORA-06512: at "SYS.DBMS_STATS",

Time to upgrade, you're facing an old bug:
http://asktom.oracle.com/pls/ask/f?p=4950:8:8868160921157129407::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:4541159655224