Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query gives incorrect results
This isn't MS SQL Server; a modicum of intelligence is assumed. Just cause
it doesn't say in the package don't do it, doesn't mean you should. You
might be able to log in as sys and manually add rows to system catalogs, but
that isn't a smart thing either.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:bbnml4$bf2$1_at_dackel.pdb.sbs.de...Received on Thu Jun 05 2003 - 19:41:12 CDT
> Jim Kennedy wrote:
> > You could read the docs and find out that you should never analyze
> > the sys schema.
> > Jim
> >
> >
> >> This last case seems related to cost-based optimizer. Try again after
> >> EXECUTE sys.dbms_utility.analyze_schema ('SYS', method=>'COMPUTE');
> >> or
> >> EXECUTE sys.dbms_utility.analyze_database (method=>'COMPUTE');
>
> OTOH, the dbms_stats packe doesn't seem to have such a limitation.
>
> Lots of Greetings!
> Volker
> --
> While it is a known fact that programmers
> never make mistakes, it is still a good idea
> to humor the users by checking for errors at
> critical points in your program.
> -Robert D. Schneider, "Optimizing INFORMIX
> Applications"
>
>
>