update the statistics info. You must run this or your system will go
veery veery slllllllllllloooooooooowwww.
Med vennlig hilsen
Torgeir Toms
Systemkonsulent Teknisk IT
==================================
Good Judgment Comes From Experience. Experiences Comes From Bad
Judgment.
=====================================
-----Opprinnelig melding-----
Fra: elianill [mailto:[EMAIL PROTECTED]
Sendt: 2. januar 2004 18:04
Til: [EMAIL PROTECTED]
Emne: Re: SV: SV: [development-axapta] Upgrade oracle database from 2.5
to 3.0 SP2 - Error
Hi,
thank you for all your hints! Reindexing of database using SQL-
Administrator succeded. Oracle-Administration was not necessary
anymore.
Thank you!
Best regards,
Elia
--- In [EMAIL PROTECTED], "Torgeir Toms"
<[EMAIL PROTECTED]> wrote:
> Hi
> There is a job in axapta 3.0 who collects statistics for Axapta.
You
> find it under administrator/setup/Oracle-Setup/statistics - Run it
form
> there with compute.
> if this does not work - i will help you doing it directly in
oracle
>
> Statistics are info about datadistribution for the optimizer in
Oracle -
> It tells Oracle how to fetch data in the most effician way. Which
index
> to use etc....
>
>
> Med vennlig hilsen
> Torgeir Toms
> Systemkonsulent Teknisk IT/OracleDBA
>
> ==================================
> Good Judgment Comes From Experience. Experiences Comes From Bad
> Judgment.
> =====================================
>
> -----Opprinnelig melding-----
> Fra: elianill [mailto:[EMAIL PROTECTED]
> Sendt: 2. januar 2004 16:55
> Til: [EMAIL PROTECTED]
> Emne: Re: SV: [development-axapta] Upgrade oracle database from
2.5 to
> 3.0 SP2 - Error
>
>
> Hi!
> 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.
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.
