RE: How to prevent DUAL having more than 1 row

Hi Babu,

I can't tell you how this happened, but I can suggest an unsupported way of making sure that it never happens again. The APT script "replace_dual.sql" at http://www.ixora.com.au/scripts/cache.htm#replace_dual can replace the SYS.DUAL table with a view onto X$DUAL. Once that's done, it will not be possible for extra rows to appear in DUAL again. From a performance point of view, there is a slight increase in the parse overhead, but a slight reduction is the execution cost of statements that refer to DUAL. Once again, this is unsupported - mentioned for information only.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@

-----Original Message-----
From: babu.nagarajan_at_mail.iflexsolutions.com Sent: Thursday, 7 September 2000 21:33
To: ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com Subject: dual having more than 1 row

In one of the databases here, count(*) from dual gave me 3. I deleted two rows based on the rowid's and now things are working fine. I was wondering how it could happen in the first place. No, no one logging in as SYS inserted this. Received on Thu Sep 07 2000 - 10:12:19 CDT