RE: dual
If you did not commit the inserts to dual, then everyone will only see one row. If you committed the data and still one row appeared, then you must have a row defined for dual. Suggestion: Don't add more rows to dual if you value your dba life. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, October 30, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject:dual List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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).
RE: dual
It's because we designed it that way. In earlier releases (can't remember the specific version we brought this in with), you could put more than one row in DUAL and then select them all, but all the things that should have returned only one row then failed with a 1403 (?) error - single row query returning more than one row. I remember well way way back in time before I joined Oracle having the fun of trying to debug why all our clients apps failed the night after we let a manager do the database maintenance. The forms that the apps used all included the date and time on the screen, and of course the manager had somehow ended up with two rows in DUAL, hence the failure. Very simple to address, by just deleting the extra row (and of course, never letting that manager do database maintenance again!). In due course, Oracle realized that DUAL was a special table and built into the kernel the functionality you mention to ensure that only one row is ever returned and hence those types of problems should not occur any more. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, October 31, 2003 3:55 AM To: Multiple recipients of list ORACLE-L List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman 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).
Re: dual
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('Y');
1 row created.
10:42:05 dv03insert into sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:dual
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
RE: dual
Do you think it
will work if it has no rows ?
Waleed
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003
1:44 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: dualYou may find
this interesting. Looks like a
'where rownum = 1' is always imposed on dual. Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a
trashable test database. Jared === 10:42:04 dv03@dt 10:42:05 dv03 10:42:05
dv03set echo on 10:42:05
dv03 10:42:05 dv03create table
jkstill.dual as select * from sys.dual; Table created. 10:42:05
dv03 10:42:05 dv03select *
from jkstill.dual; D
- X 1 row selected.
10:42:05 dv03 10:42:05 dv03drop table jkstill.dual;
Table dropped. 10:42:05 dv03 10:42:05 dv03insert into sys.dual values('Y'); 1 row created. 10:42:05 dv03insert into sys.dual values('Z'); 1 row created. 10:42:05 dv03 10:42:05
dv03commit; Commit
complete. 10:42:05 dv03
10:42:05 dv03select * from
sys.dual; D - X
1 row selected. 10:42:05 dv03 10:42:05 dv03create table jkstill.dual as select * from
sys.dual; Table created.
10:42:05 dv03 10:42:05 dv03select * from jkstill.dual;
D - X Y Z
3 rows selected. 10:42:05 dv03 10:42:05 dv03drop table jkstill.dual; Table dropped. 10:42:05 dv03 10:42:05
dv03delete from sys.dual; 1
row deleted. 10:42:05
dv03delete from sys.dual; 1
row deleted. 10:42:05
dv03delete from sys.dual; 1
row deleted. 10:42:05
dv03 10:42:05 dv03insert into
sys.dual values('X'); 1 row
created. 10:42:05
dv03commit; Commit
complete. 10:42:05 dv03
10:42:05 dv03 10:42:05 dv03create table jkstill.dual as select *
from sys.dual; Table
created. 10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual; D - X
1 row selected. 10:42:05 dv03 10:42:05 dv03drop table jkstill.dual; Table dropped. 10:42:05 dv03
[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:
Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc:
Subject:
dualList, here is a rtfm question which I was scared to ask, but
itsbothering me too much so I just can't stay quite :"why do
multiple inserts into sys.dual complete sucessfully when
connectedassysdba, but a subsequent select * from dual show only 1 row
?"-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net-- Author:
[EMAIL PROTECTED]INET:
[EMAIL PROTECTED]Fat City Network Services --
858-538-5051 http://www.fatcity.comSan Diego, California
-- Mailing list and web hosting
services-To
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing
list you want to be removed from). You mayalso send the HELP command
for other information (like
subscribing).
RE: dual
I have seen many databases crash, yes crash, when
dual had more than one row or less than one?
Why you say?
As someone pointed out, this was an internal table to the kernel so
Oracle used it as they felt. It
was and still is considered a heartbeat mechanism within the kernel. In other words, dont mess with it.
Thank You
Stephen
P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313)
227-4350
Mobile: (248)
408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-Original
Message-
From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
2:05 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: dual
Do you think
it will work if it has no rows ?
Waleed
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003
1:44 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: dual
You may find this interesting.
Looks like a 'where rownum = 1' is
always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other
than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into
sys.dual values('Y');
1 row created.
10:42:05 dv03insert into
sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from
sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03delete from
sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into
sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table
jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from
jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table
jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by:
[EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:dual
List, here is a
rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
RE: dual
Didn't try no rows. I imagine all kinds of things would break.
Khedr, Waleed [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 11:04 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dual
Do you think it will work if it has no rows ?
Waleed
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: dual
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('Y');
1 row created.
10:42:05 dv03insert into sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:dual
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
Re: dual
Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 23:49 It's because we designed it that way. In earlier releases (can't remember the specific version we brought this in with), you could put more than one row in DUAL and then select them all, but all the things that should have returned only one row then failed with a 1403 (?) error - single row query returning more than one row. I remember well way way back in time before I joined Oracle having the fun of trying to debug why all our clients apps failed the night after we let a manager do the database maintenance. The forms that the apps used all included the date and time on the screen, and of course the manager had somehow ended up with two rows in DUAL, hence the failure. Very simple to address, by just deleting the extra row (and of course, never letting that manager do database maintenance again!). In due course, Oracle realized that DUAL was a special table and built into the kernel the functionality you mention to ensure that only one row is ever returned and hence those types of problems should not occur any more. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, October 31, 2003 3:55 AM To: Multiple recipients of list ORACLE-L List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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).
RE: dual
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results. Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys/system stuff were known to be culprit.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 30 Oct 2003 11:24:24 -0800
I have seen many databases crash, yes crash, when dual had more than one row
or less than one?
Why you say? As someone pointed out, this was an internal table to the
kernel so Oracle used it as they felt. It was and still is considered a
heartbeat mechanism within the kernel. In other words, don't mess with it.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-Original Message-
Sent: Thursday, October 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Do you think it will work if it has no rows ?
Waleed
-Original Message-
Sent: Thursday, October 30, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('Y');
1 row created.
10:42:05 dv03insert into sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:dual
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.
_
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet
Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
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
RE: dual
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, October 30, 2003 3:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dual Didn't try no rows. I imagine all kinds of things would break. [Shrek] yes they will... trust me. you really don't want to go there. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] "Oh dear, I think you'll find reality's on the blink again." -- Marvin The Paranoid Android
RE: dual
I encountered the same problem once many years ago, for the same reason.
Quite a pickle for a newbie - OWW bailed me out on that one. :)
Jraed
M Rafiq [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 12:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: dual
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results. Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys/system stuff were known to be culprit.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 30 Oct 2003 11:24:24 -0800
I have seen many databases crash, yes crash, when dual had more than one row
or less than one?
Why you say? As someone pointed out, this was an internal table to the
kernel so Oracle used it as they felt. It was and still is considered a
heartbeat mechanism within the kernel. In other words, don't mess with it.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-Original Message-
Sent: Thursday, October 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Do you think it will work if it has no rows ?
Waleed
-Original Message-
Sent: Thursday, October 30, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('Y');
1 row created.
10:42:05 dv03insert into sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:dual
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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).
The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.
_
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet
Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http
RE: dual
Refer to
http://asktom.oracle.com/pls/ask/f?p=4950:8:5481819534388360937::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388,
for the answers to some of your questions below. I think it's safe to say
that DUAL is a rather 'magic' table. The normal rules for DML don't work
on it; I'd not even posit that 'rownum 1' is in there anywhere. More
likely it's intercepted by the optimizer and treated specially, without
any actual data access, in certain contexts.
Adam
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 02:49 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: dual
I encountered the same problem once many years ago, for the same reason.
Quite a pickle for a newbie - OWW bailed me out on that one. :)
Jraed
M Rafiq [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 12:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: dual
I have observed 2 rows in dual till version 7.3.4. All application using
dual in their logic having more than 2 rows were giving wrong results.
Quick
fix was to track it and delete more than one row(s). Duplicate import of
sys/system stuff were known to be culprit.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 30 Oct 2003 11:24:24 -0800
I have seen many databases crash, yes crash, when dual had more than one
row
or less than one?
Why you say? As someone pointed out, this was an internal table to the
kernel so Oracle used it as they felt. It was and still is considered a
heartbeat mechanism within the kernel. In other words, don't mess with
it.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web: www.compuware.com
-Original Message-
Sent: Thursday, October 30, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Do you think it will work if it has no rows ?
Waleed
-Original Message-
Sent: Thursday, October 30, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
You may find this interesting.
Looks like a 'where rownum = 1' is always imposed on dual.
Same results on 8.1.7.4 and 9.2.0.4
Don't try this on anything other than a trashable test database.
Jared
===
10:42:04 dv03@dt
10:42:05 dv03
10:42:05 dv03set echo on
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('Y');
1 row created.
10:42:05 dv03insert into sys.dual values('Z');
1 row created.
10:42:05 dv03
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03select * from sys.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
Y
Z
3 rows selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03delete from sys.dual;
1 row deleted.
10:42:05 dv03
10:42:05 dv03insert into sys.dual values('X');
1 row created.
10:42:05 dv03commit;
Commit complete.
10:42:05 dv03
10:42:05 dv03
10:42:05 dv03create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03
10:42:05 dv03select * from jkstill.dual;
D
-
X
1 row selected.
10:42:05 dv03
10:42:05 dv03drop table jkstill.dual;
Table dropped.
10:42:05 dv03
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 08:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:dual
List, here is a rtfm question which I was scared to ask, but its
bothering me too much so I just can't stay quite :
why do multiple inserts into sys.dual complete sucessfully when connected
as
sysdba, but a subsequent select * from dual show only 1 row ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
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
Re: DUAL
Hi, Is the link misspelled? It says Page cannot be found.. Jai Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 11:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DUAL So listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@AshleyfurnTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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).
RE: DUAL
The link is not wrong. Note, however, that a hard return split it into two. Also, I think the word Yechiel Adar was meaning to use was : deleterious :harmful often in a subtle or unexpected way deleterious effects deleterious to health -Original Message- Sent: Tuesday, December 17, 2002 6:49 AM To: Multiple recipients of list ORACLE-L Hi, Is the link misspelled? It says Page cannot be found.. Jai Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 11:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DUAL So listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.comcc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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
RE: DUAL
Title: RE: DUAL That's it. I'm inventing my own dummy table. CREATE TABLE dummy (DUAL varchar2(20)); -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 10:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: DUAL So listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel AdarMehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-LHowdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. "Farnsworth, Dave" DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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).
Re: DUAL
I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: DUAL
I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM To: Multiple recipients of list ORACLE-L I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see
RE: DUAL
Those guys retired... ;) They ought to put that stuff in that RDA script :) - Kirti -Original Message- Sent: Tuesday, December 17, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM To: Multiple recipients of list ORACLE-L I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: DUAL
That's a good idea. You ought to suggest them to put it in. -Original Message- Sent: Tuesday, December 17, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Those guys retired... ;) They ought to put that stuff in that RDA script :) - Kirti -Original Message- Sent: Tuesday, December 17, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM To: Multiple recipients of list ORACLE-L I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji 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).
Re: DUAL
The same thing happened to me as well. There were 2 rows in dual, and it caused some really strange problems with Oracle Financials. The support tech and Oracle knew his stuff, and had me check it. I have no idea how 2 rows came to be in dual, but it sure was a mess. Jared Stephane Paquette [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 10:26 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DUAL I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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
RE: DUAL
It also improves your BCHR! -Original Message- Sent: Tuesday, December 17, 2002 1:45 PM To: Multiple recipients of list ORACLE-L That's a good idea. You ought to suggest them to put it in. -Original Message- Sent: Tuesday, December 17, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Those guys retired... ;) They ought to put that stuff in that RDA script :) - Kirti -Original Message- Sent: Tuesday, December 17, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM To: Multiple recipients of list ORACLE-L I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a big bank. Poor dba ... --- Yechiel Adar [EMAIL PROTECTED] a écrit : RE: DUALSo listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel Adar Mehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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).
RE: DUAL
Title: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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).
Re: DUAL
Title: RE: DUAL So listen up: For better April 1'st - add another record to dual. That is known to cause a deteriorating effect on developers. :-) Yechiel AdarMehish - Original Message - From: Jeremy Pulcifer To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 6:29 PM Subject: RE: DUAL Careful. We are listening. ;-) (that woulda messed me up for a while) -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: DUAL Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. "Farnsworth, Dave" DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.com cc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831 497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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).
RE: DUAL
Thanks for the great suggestion! I will remember to use that one when those developers start getting too lippy ;-) Babette -Original Message- Richard Sent: Thursday, December 12, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.comcc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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).
RE: DUAL
Hallo, Dave- what is, Dual for Dummies? -Original Message- Sent: Thursday, December 12, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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).
Re: DUAL
Howdy, I believe that truncating DUAL has also been known to leave developers scratching their head. Of course I could never recommend that anyone try it though. Farnsworth, Dave DFarnsworth@Ashleyfurn To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] iture.comcc: Sent by: Subject: DUAL [EMAIL PROTECTED] 13/12/2002 05:14 Please respond to ORACLE-L Hallo, Problems with dual, please read link http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci831497,00.html TIA, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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).
RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/
Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list ORACLE-L DBA/Developer/NYC As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/
We are using PostgreSQL, but still have problems with statistics. Sometimes after VACUUM ANALYZE optimizer doesn't use indexes and performance goes down. JP On Friday 20 September 2002 18:43, you wrote: Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list ORACLE-L DBA/Developer/NYC As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/
Jan, Which version of PostgrSQL are you using? --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, September 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L DBA/Developer/ We are using PostgreSQL, but still have problems with statistics. Sometimes after VACUUM ANALYZE optimizer doesn't use indexes and performance goes down. JP On Friday 20 September 2002 18:43, you wrote: Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list ORACLE-L DBA/Developer/NYC As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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).
Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/
7.0 JP On Friday 20 September 2002 20:29, you wrote: Jan, Which version of PostgrSQL are you using? --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, September 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L DBA/Developer/ We are using PostgreSQL, but still have problems with statistics. Sometimes after VACUUM ANALYZE optimizer doesn't use indexes and performance goes down. JP On Friday 20 September 2002 18:43, you wrote: Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list ORACLE-L DBA/Developer/NYC As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
RE: DUAL Was: Consulting Position Available-Oracle DBA/Developer/
Thanks, Jan. Are you still at work? --Walt (1.85254E-16ly tall) Weaver -Original Message- Sent: Friday, September 20, 2002 1:59 PM To: Multiple recipients of list ORACLE-L DBA/Developer/ 7.0 JP On Friday 20 September 2002 20:29, you wrote: Jan, Which version of PostgrSQL are you using? --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, September 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L DBA/Developer/ We are using PostgreSQL, but still have problems with statistics. Sometimes after VACUUM ANALYZE optimizer doesn't use indexes and performance goes down. JP On Friday 20 September 2002 18:43, you wrote: Ditto for PostgreSQL. For portability you can create a dual table but you have to ensure that it only has one row. ;-) I finding that portability between PostgreSQL and Oracle is easier than most... same to_date, to_char functions, and stuff. Seems like that's part of Postgres' strategy. -Original Message- Sent: Friday, September 20, 2002 9:24 AM To: Multiple recipients of list ORACLE-L DBA/Developer/NYC As well as in MySQL There is no need for such table in SQL Server. If you need, you do just: select 'whatever' without from clause. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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).
RE: DUAL revisited
I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are
RE: DUAL revisited
Just wondering here but has anyone tried doing that select from something like v$database; Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 187 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed that looks pretty good to me!! -Original Message- Sent: Friday, August 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: david hill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: DUAL revisited
...if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:15 AM I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL
RE: DUAL revisited
But I don't get this error when I query from dual just from the new v$dual. Kathy -Original Message- Sent: Friday, August 02, 2002 12:54 PM To: Multiple recipients of list ORACLE-L ...if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:15 AM I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention,
RE: DUAL revisited
Title: RE: DUAL revisited -Original Message- From: Kathy Duret [mailto:[EMAIL PROTECTED]] But I don't get this error when I query from dual just from the new v$dual. That's because your v$dual view is assessing a SYS.X$ table. To do an explain plan on a SYS.X$ table you have to be signed on as SYS. A more knowledgeable person may be able to tell you why.
Re: DUAL revisited
Correct. DUAL is a table owned by SYS for which SELECT permissions have been granted to PUBLIC. V$DUAL is a view on a special fixed table named X$DUAL. The SELECT permissions here are granted on the *view*; they cannot be granted on a fixed table (i.e. X$ table). So, you're queries succeed because they are querying the view, which is able to query the fixed table because the view belongs to SYS and inherits the permissions of SYS (i.e. definer's rights). However, EXPLAIN PLAN tries to access the underlying table and fails, because you are running EXPLAIN PLAN as a user other than SYS... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 3:03 PM But I don't get this error when I query from dual just from the new v$dual. Kathy -Original Message- Sent: Friday, August 02, 2002 12:54 PM To: Multiple recipients of list ORACLE-L ..if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:15 AM I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Zoltak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: DUAL revisited
Sorry brain dead. Been working day and night for 5 days. Not much sleep. Makes perfect sense now. Kathy -Original Message- Sent: Friday, August 02, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Correct. DUAL is a table owned by SYS for which SELECT permissions have been granted to PUBLIC. V$DUAL is a view on a special fixed table named X$DUAL. The SELECT permissions here are granted on the *view*; they cannot be granted on a fixed table (i.e. X$ table). So, you're queries succeed because they are querying the view, which is able to query the fixed table because the view belongs to SYS and inherits the permissions of SYS (i.e. definer's rights). However, EXPLAIN PLAN tries to access the underlying table and fails, because you are running EXPLAIN PLAN as a user other than SYS... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 3:03 PM But I don't get this error when I query from dual just from the new v$dual. Kathy -Original Message- Sent: Friday, August 02, 2002 12:54 PM To: Multiple recipients of list ORACLE-L ..if you're going to query from an account other than SYS, then please SET AUTOTRACE TRACEONLY STATISTICS (instead of SET AUTOTRACE ON) so it doesn't try to do an EXPLAIN PLAN. You cannot grant SELECT on X$ tables to anyone other than SYS, which affects EXPLAIN PLAN also... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:15 AM I followed the instructions but I get the error below. I do not get the same error when I select from dual. And yes I did to the public grant. And other clues? DB 8.1.7.3 Thanks Kathy Execution Plan -- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics -- 0 recursive calls 0 db block gets 0 consistent gets 0 physical reads 0 redo size 371 bytes sent via SQL*Net to client 426 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed -Original Message- Sent: Friday, August 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I've been reading the thread on DUAL vs X$DUAL, read the referenced article and tried some testing on our system. I do a simple select from DUAL and I get the same statistics as were in the article, but sometimes I also get 1 memory sort. Does anyone know why this would be? And if this is true, that really makes me want to change over to X$DUAL. Also, what is the consensus about creating a view for DUAL that references X$DUAL? I'm running the Oracle Application and cannot change all of their code to use something other than DUAL, and there is a lot of it. Here are the statistics on the select. Notice the difference between the first vs repeat of the same seelct. Connected to: Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option JServer Release 8.1.7.1.1 - Production SQL set autotrace traceonly SQL select 'y' from dual; Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed SQL / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 10 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1) Statistics -- 0 recursive calls 4 db block gets 1 consistent gets 0 physical reads 0 redo size 361 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed SQL Thanks for your input. John Zoltak North American Mfg Co 4455 East 71st Street Cleveland Ohio 44105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John
RE: DUAL related
Kinda neat. Thanks! Patrice. -Original Message- Sent: Saturday, June 22, 2002 2:38 PM To: Multiple recipients of list ORACLE-L For those who want to optimize select something from dual, look at the following link... http://www.oracledba.co.uk/tips/dual_speed.htm Regards, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: dual error
i used sql.bsq and it worked shirish -Original Message- Sent: Wednesday, June 20, 2001 6:47 PM To: LazyDBA.com Discussion Can you enlighten us with the resolution ? -Original Message- Sent: 20 June 2001 14:18 To: LazyDBA.com Discussion thanks all,,my probs with dual is is solved now Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: dual error
thanks all,,my probs with dual is is solved now Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT RE: dual error
re: Your sig line on parachutes. Yes, but to be considered properly prepared for use, they must be closed. -Original Message- Sent: Wednesday, June 20, 2001 10:06 AM To: Multiple recipients of list ORACLE-L thanks all,,my probs with dual is is solved now Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: dual error
it creates various support tables and views for eg dual, or tab(when u do select * from tab) etc for more info open the sql.bsq from u'r orant/home/rdbms80/admin/sql.bsq Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shirish Khapre INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
