You need Rdb (Oracle's other database) for that to work:
eg:
SQL> seelct count(*) from pot;
%SQL-I-SPELLCORR, identifier SEELCT replaced with SELECT
334
1 row selected
SQL> show version
Current version of SQL is: Oracle Rdb SQL V7.1-101
Underlying versions are:
Database with filename pas_batch_db
Oracle Rdb V7.1-10
Rdb/Dispatch V7.1-101 (OpenVMS Alpha)
Regards,
Bruce
-----Original Message-----
Sent: Tuesday, 22 July 2003 12:04 PM
10gR2 will automatically correct the errors.
I'm waiting for the version that will know that I *meant* to type
"select" when I actually type "seelct"
--- Daniel Fink <[EMAIL PROTECTED]> wrote:
> Okay, so its Monday...
>
> What I meant to say is that are the queries with different execution
> plans the ones encountering 7445s. If there is a common thread in the
> execution plans (i.e. hash join instead of nested loops), then the hj
> may be triggering the 7445s.
>
> Actually, 10g will have a new "FORETELL PLAN" feature that will
> predict the execution plan and all associated errors, complaints,
> incorrect data...
>
> "Gogala, Mladen" wrote:
> >
> > Actually, I'm quite unaware of ORA-07745 as an execution plan. Can
> "EXPLAIN
> > PLAN"
> > foretell the error?
> >
> > Mladen Gogala
> > Oracle DBA
> > Phone:(203) 459-6855
> > Email:[EMAIL PROTECTED]
> >
> > -----Original Message-----
> > Sent: Monday, July 21, 2003 6:20 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Michael,
> > When you say 'different execution plans', what are the
> differences?
> > Is the choice in execution plans causing the ORA-07445? If so, why
> are the
> > execution plans different (there has to be a reason)? Statistics,
> > parameters, etc. will alter the execution plan choices.
> > The 7445 definitely deserves a call to Oracle Support
> (through SAP
> > if need be). 7445s are a royal pain to diagnose (like 600s).
> >
> > Daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
