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 <rafiq9857_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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_at_fatcity.com; oracledba_at_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_at_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_at_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_at_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_at_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
Received on Fri Sep 08 2000 - 21:37:13 CDT
