If 9202 there is a bug regarding DBMS_STATS using "Estimate statistics"
if it is just the statistics who fails, use DBMS_Stats to first delete
and then recreate the statistics on your tables using "compute
statistics" and cascade=True and generate histogramms for your columns
Med vennlig hilsen
Torgeir Toms
Systemkonsulent Teknisk IT/Oracle DBA
________________________________________________________________________
____________________________
==================================
Good Judgment Comes From Experience. Experiences Comes From Bad
Judgment.
=====================================
-----Opprinnelig melding-----
Fra: elianill [mailto:[EMAIL PROTECTED]
Sendt: 2. januar 2004 16:06
Til: [EMAIL PROTECTED]
Emne: [development-axapta] Upgrade oracle database from 2.5 to 3.0 SP2 -
Error
Hallo,
when upgrading oracle database from 2.5 to 3.0 SP2 dataupdate-
job "updateOracleStatistics" is always terminated with following
error-message:
SQL-error: ORA-00904: invalid columne name
ORA-06512: in "SYS.DBMS_STATS", row 9375
ORA-06512: in "SYS.DBMS_STATS", row 9857
ORA-06512: in "SYS.DBMS_STATS", row 10041
ORA-06512: in "SYS.DBMS_STATS", row 10095
ORA-06512: in "SYS.DBMS_STATS", row 10072
ORA-06512: in "BMSSA.AXAPTA", row 8
ORA-06512: in row 1
How to go on? Any help appreciated!
Thank you in advance!
Best regards,
Elia
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
