You're right. I haven't done one in over two years. Forgot about that.
----- Original Message -----
From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, September 11, 2000 3:10 PM
Subject: Re: How to prevent DUAL having more than 1 row
> If you require to use full dump of database , you are not required to run
> catalog or other cat* scripts as your dump contains all required data
> dictionery stuff and yes you can import full dump just after creation of
> database.
> Regards
> Rafiq
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Fri, 08 Sep 2000 19:40:26 -0800
>
> 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 -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, September 08, 2000 3:21 PM
>
>
> > 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
> > also send the HELP command for other information (like subscribing).
>
> --
> Author: Tom Pall
> INET: tom_at_cdproc.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
> 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 Tue Sep 12 2000 - 18:46:29 CDT
