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

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