Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_STATS "Missing expression"

DBMS_STATS "Missing expression"

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Thu, 25 Aug 2005 11:19:17 -0700
Message-ID: <HYnPe.46996$Ji4.3473@fed1read03>


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
Received on Thu Aug 25 2005 - 13:19:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US