DBMS_STATS "Missing expression"

RDBMS version: Oracle 8i Enterprise 8.1.5.0.0 (Yes, I know it's old and unsupported.)
Platform: Solaris 2.6
HW: Sun Enterprise 450, 1 processor, 1 gig memory. Two external dive arrays connected via SCSI with software LVM (Veritas).

I don't have access to metalink and the web doesn't return any useful results.

Has anyone seen an error of the kind:

ORA-00936: missing expression
ORA-06512: at "SYS.DBMS_STATS", line 3867
ORA-06512: at "SYS.DBMS_STATS", line 3998
ORA-06512: at "SYS.DBMS_STATS", line 4161
ORA-06512: at "SYS.DBMS_STATS", line 4143

when trying to execute a statement of the kind: exec DBMS_STATS.GATHER_SCHEMA_STATS( ownname=>'SCHEMANAME' );

It's worked before. All I remember doing new is creating a table and a function-based index. Other function-based indexes already exist in the database and the procedure worked fine.

Any help would be appreciated.

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer




"If you don't eat your meat, you cannot have any pudding.

"How can you have any pudding if you don't eat your meat?!?!"

---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup