dbms_stats.set_index_stats usage issues
I am trying to update the index statistics for a table in my dummy database using the dbms_stats.set_index_stats. The environment is as below :
1. Production data base is on Sun Solaris Oracle 10gR2
2. My Dummy Databases is on a Dell Laptop Windows 7 SP1 using Oracle 11gR2
3. I am trying to issue the below command to set the index stats for a table :
DBMS_STATS.SET_INDEX_STATS ( ownname =>'DAMSMGR',
indname =>'DAMS_TP_GFA_INVO_REASON_AK1',
partname =>null,
stattab => null,
statid=>null,
numrows =>0,
numblks =>0,
numdist =>0,
clstfct =>0,
avglblk =>0,
avgdblk =>0,
indlevel =>0,
no_invalidate => true,
guessq => NULL ,
cachedblk =>NULL,