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.

Report message to a moderator

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');

Report message to a moderator

Previous Topic: How indexes behave on a varchar field
Next Topic: TEMP Space used by each user - HOWTO?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 20:19:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.