Oracle Database Express Edition (XE)

Hi all,

I have recreated a new database with character set ZHT16BIG5. And then I imported the data and run the following statement to gather schema statistics.

exec dbms_stats.gather_schema_stats( -
ownname => 'BPSADM', -
estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -
granularity => 'ALL', -
method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO', -
degree =>1, -
options => 'GATHER AUTO', -
cascade => TRUE -
);

After about 2 mins, I got this error.
BEGIN dbms_stats.gather_schema_stats( ownname => 'BPSADM',
estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, granularity => 'ALL
', method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO', degr
ee =>1, options => 'GATHER AUTO', cascade => TRUE
); END;

*
ERROR 在行 1:
ORA-01401: inserted value too large
ORA-06512: 在 "SYS.DBMS_STATS", line 13210
ORA-06512: 在 "SYS.DBMS_STATS", line 13517
ORA-06512: 在 "SYS.DBMS_STATS", line 13634
ORA-06512: 在 "SYS.DBMS_STATS", line 13593
ORA-06512: 在 line 1

There is no problem if I use the analyze command for this. But Oracle is suggested to use the new dbms_stat package. Can any tell that whether it is a bug on the package dbms_stats or not?

Thanks in advance,

Antony