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 dv03>set echo on 10:42:05 dv03> 10:42:05 dv03>create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03> 10:42:05 dv03>select * from jkstill.dual;
D - X
1 row selected.
10:42:05 dv03> 10:42:05 dv03>drop table jkstill.dual;
Table dropped.
10:42:05 dv03>
10:42:05 dv03>insert into sys.dual values('Y');1 row created.
10:42:05 dv03>insert into sys.dual values('Z');
1 row created.
10:42:05 dv03> 10:42:05 dv03>commit;
Commit complete.
10:42:05 dv03> 10:42:05 dv03>select * from sys.dual;
D - X
1 row selected.
10:42:05 dv03> 10:42:05 dv03>create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03> 10:42:05 dv03>select * from jkstill.dual;
D - X Y Z
3 rows selected.
10:42:05 dv03> 10:42:05 dv03>drop table jkstill.dual;
Table dropped.
10:42:05 dv03> 10:42:05 dv03>delete from sys.dual;
1 row deleted.
10:42:05 dv03>delete from sys.dual;
1 row deleted.
10:42:05 dv03>delete from sys.dual;
1 row deleted.
10:42:05 dv03>
10:42:05 dv03>insert into sys.dual values('X');1 row created.
10:42:05 dv03>commit;
Commit complete.
10:42:05 dv03> 10:42:05 dv03> 10:42:05 dv03>create table jkstill.dual as select * from sys.dual;
Table created.
10:42:05 dv03> 10:42:05 dv03>select * from jkstill.dual;
D - X
1 row selected.
10:42:05 dv03> 10:42:05 dv03>drop 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 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 mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
