Toad World® Forums

[Fwd: error when running SQL optimizer] [1 Attachment]


#1

-------- Original Message --------
Subject: [toad] error when running SQL optimizer
Date: Thu, 11 Feb 2010 16:44:33 -0500

[ Attachment(s) from Wendy Penfold included below]

-------- Original Message -------- Subject:
[toad] error when running SQL optimizer

Date:
Thu, 11 Feb 2010 16:44:33 -0500

From:
Wendy Penfold

To:
toad@yahoogroups.com

Issue:
SQL optimizer is encountering an error and then closing on this sql
statement:

SELECT O.Spriden_pidm
,O.Spriden_id
, O.Spriden_last_name
|| ‘, ’
|| O.Spriden_first_name
|| ’ ’
|| O.Spriden_mi
|| ’ ’
|| O.Spriden_id
,O.ROWID
,COUNT (DISTINCT (O.Spriden_pidm)) OVER ()
FROM Spriden N, Spriden O
WHERE N.Spriden_pidm = O.Spriden_pidm
AND N.Spriden_change_ind IS NULL
AND O.Spriden_entity_ind = NVL (’’, O.Spriden_entity_ind)
AND O.Spriden_pidm IN (SELECT Y.Spriden_pidm
FROM Spriden Y
WHERE (Y.Spriden_search_last_name LIKE ‘BOUTWELL’
OR ‘BOUTWELL’ IS NULL)
AND (Y.Spriden_search_first_name LIKE ‘KALI’
OR ‘KALI’ IS NULL)
AND (Y.Spriden_search_mi LIKE ‘’
OR ‘’ IS NULL))
ORDER BY N.Spriden_search_last_name
,N.Spriden_search_first_name
,N.Spriden_search_mi
,N.Spriden_id
,O.Spriden_change_ind DESC;

moz-screenshot-146.jpeg

moz-screenshot-147.jpeg


#2

Hey Wendy,

I can open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad specific
features/screens.

http://sqloptimizeroracle.inside.quest.com/index.jspa

Jeff
moz-screenshot-147.jpeg


#3

Hey Wendy,

I can open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad specific
features/screens.

http://sqloptimizeroracle.inside.quest.com/index.jspa

Jeff
moz-screenshot-146.jpeg


#4

Hi Jeff, thanks. I opened a support case. W

Jeff Smith wrote:

Hey Wendy,

I can open a support case for you if you’d like, or you can send this
over to the SQL Optimizer Community. The Yahoo group is mostly for
the Toad specific features/screens.

http://sqloptimizeroracle.inside.quest.com/index.jspa

Jeff

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Wendy Penfold
Sent: Thursday, February 11, 2010 4:49 PM
To: ToadList
Subject: [Fwd: [toad] error when running SQL optimizer] [1 Attachment]

[Attachment(s) from Wendy Penfold included below]

-------- Original Message --------

*Subject: *

[toad] error when running SQL optimizer

*Date: *

Thu, 11 Feb 2010 16:44:33 -0500

*Hi Jeff, thanks. I opened a support case. W Jeff Smith wrote: Hey Wendy, I can
open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad
specific features/screens. http://sqloptimizer oracle.inside. quest.com/
index.jspa Jeff
att1.dat (10 KB)


#5

Hi Jeff, thanks. I opened a support case. W

Jeff Smith wrote:

Hey Wendy,

I can open a support case for you if you’d like, or you can send this
over to the SQL Optimizer Community. The Yahoo group is mostly for
the Toad specific features/screens.

http://sqloptimizeroracle.inside.quest.com/index.jspa

Jeff

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] *On Behalf
Of *Wendy Penfold
Sent: Thursday, February 11, 2010 4:49 PM
To: ToadList
Subject: [Fwd: [toad] error when running SQL optimizer] [1 Attachment]

[Attachment(s) from Wendy Penfold included below]

-------- Original Message --------

*Subject: *

[toad] error when running SQL optimizer

*Date: *

Thu, 11 Feb 2010 16:44:33 -0500

*Hi Jeff, thanks. I opened a support case. W Jeff Smith wrote: Hey Wendy, I can
open a support case for you if you’d like, or you can send this over
to the SQL Optimizer Community. The Yahoo group is mostly for the Toad
specific features/screens. http://sqloptimizer oracle.inside. quest.com/
index.jspa Jeff
att1.dat (13.2 KB)