|
|
|
|
Re: Gather schema statistics [message #530753 is a reply to message #530747] |
Thu, 10 November 2011 04:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
![bala_mech2004](/forum/theme/orafaq/images/yahoo.png) ![fgdgs](/forum/theme/orafaq/images/jabber.png)
|
|
Hi,
I am getting below error while trying to gather table statistics.
SQL>
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>'DEMO,TABNAME=>'PARTS_EXCLUDED_TAB','PARTS_EXCLUDED_AUDIT_TAB','PART_PRICE_TAB','PART_TAB','PART_DESCRIPTION_TAB',METHOD_OPT= >'FOR ALL INDEXED COLUMNS',DEGREE => 8,CASCADE => TRUE);
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME=>'RIMSPO',TABNAME=>'PARTS_EXCLUDED_TAB','PARTS_EXCLUDED_AUDIT_TAB','PART_PRICE_TAB','PART_TAB','PART_DESCRIPTION_TAB',METHOD_OPT= >'FOR ALL INDEXED COLUMNS',DEGREE => 8,CASCADE => TRUE); END;
Quote: *
ERROR at line 1:
ORA-06550: line 1, column 85:
PLS-00312: a positional parameter association may not follow a named
association
ORA-06550: line 1, column 7:
Please tell me how to fix this error.
Thanks
|
|
|
|
|
|
|