Home » RDBMS Server » Performance Tuning » PROBLE IN ANALYZE
PROBLE IN ANALYZE [message #65065] Wed, 14 April 2004 02:15 Go to next message
MUHAMMAD SAFHAN GHAURI
Messages: 6
Registered: November 2000
Junior Member
HI,
I WROTE THIS ANALYZE STATEMENT

EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('AB','ESTIMATE',0,40,'FOR SLL INDEXED COLUMN SIZE 40')

THAT GIVE ME ERROR
ORA-0095
MISSING KEYWORD

ERROR AT LINE 257

THANKS IN ADVANCE.
Re: PROBLE IN ANALYZE [message #65067 is a reply to message #65065] Wed, 14 April 2004 07:57 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA('AB','ESTIMATE',0,40,'FOR ALL INDEXED COLUMNS SIZE 40');
Previous Topic: How indexes behave on a varchar field
Next Topic: TEMP Space used by each user - HOWTO?
Goto Forum:
  


Current Time: Fri Mar 29 05:11:21 CDT 2024