Thank you for answering! I am using 9204 - but I am new to oracle.
Can you explain me a bit in detail how to go on?
Should I do this all using SQL*Plus with sysdba? Do I have it during
upgradejob of Axapta or before?
Thanks for all hints.
Best regards,
Elia
--- In [EMAIL PROTECTED], "Torgeir Toms"
<[EMAIL PROTECTED]> wrote:
> What oracle version are you on?
> 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 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.
