Message-Id: <10613.116572@fatcity.com> From: "Tom Pall" Date: Fri, 8 Sep 2000 21:37:13 -0500 Subject: Re: How to prevent DUAL having more than 1 row I just checked the log of my latest full database export. I see system and all the other users. But no sys. Aren't you susposed to have created a database and run catalog, catproc, catwhatever before importing the full database export? ----- Original Message ----- From: Mohammad Rafiq To: Multiple recipients of list ORACLE-L Sent: Friday, September 08, 2000 3:21 PM Subject: RE: How to prevent DUAL having more than 1 row > Has somebody imported dmp with system data and with rows=y ignore=y. This is > one of the possible reason which happened to us in our early days with > Oracle version 5(1988-89) when ignore=y/n option was not available. > Regards > Rafiq > > Reply-To: ORACLE-L@fatcity.com > To: Multiple recipients of list ORACLE-L > Date: Thu, 07 Sep 2000 07:15:42 -0800 > > 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/ > @ > @ Going to OpenWorld? > @ Catch the Ixora performance tuning seminar too! > @ See http://www.ixora.com.au/seminars/ for details. > > > -----Original Message----- > Sent: Thursday, 7 September 2000 21:33 > To: ORACLE-L@fatcity.com; oracledba@lazydba.com > > > 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. > Then how? > > -- > Author: Steve Adams > INET: steve.adams@ixora.com.au > > 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: ListGuru@fatcity.com (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). > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > > -- > Author: Mohammad Rafiq > INET: rafiq9857@hotmail.com > > 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: ListGuru@fatcity.com (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