GUI's are ok, I do use and appreciate then, but sometimes the older methods are
1) faster and 2) more rewarding. Especially for an old fossil, like me.
Dick Goulet
____________________Reply Separator____________________
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date: 10/3/01 3:25 AM
Now now, GUI tools aren't all THAT bad! :P
Mark (GUI tool sales critter) Leith
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
-----Original Message-----
Mladen
Sent: Tuesday, October 02, 2001 17:50
To: Multiple recipients of list ORACLE-L
That is not elegant and doesn't have a GOOEY interface.
It also requires the knowledge of SQL, which is a lot
to ask from a poor little DBA like me.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 12:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:RE: Comparing data between two tables in two schema
>
>
> Why not try the time tested brute force method?
>
> Select * from <owner1>.<table1>
> intersect select * from <owner2>.<table2>;
>
> If you get the same number of rows as there are in the tables
> individually then
> they are equal. BTW: it's cheap too.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Gogala; Mladen" <[EMAIL PROTECTED]>
> Date: 10/2/2001 7:35 AM
>
> The freware "tora" tool also has some "compare" capabilities.
> I've tested
> if with whe users "scott" and "scott1" (both populated throuh
> the "demobld"
> script and, therefore containing vast masses of data) and it
> worked well.
> I haven't tested it on a real life database, mostly because the word
> "freeware"
> is considered rude in production environment.
>
> > -----Original Message-----
> > From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 01, 2001 11:15 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Comparing data between two tables in two schema
> >
> >
> > I think that the Change Management Pack of the Oracle
> > Enterprise Manager may
> > be useful to you.
> >
> >
> >
> > >From: "Rao, Maheswara" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: Comparing data between two tables in two schema
> > >Date: Mon, 01 Oct 2001 12:29:41 -0800
> > >
> > >List,
> > >
> > >I have two schema. The tables in both schema are having
> > same name and
> > >structures.
> > >
> > >Is there any tool to compare the data between two schema tabels?
> > >
> > >Thanks,
> > >
> > >Rao
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Rao, Maheswara
> > > INET: [EMAIL PROTECTED]
> > >
> > >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: [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).
> >
> >
> > _________________________________________________________________
> > Descargue GRATUITAMENTE MSN Explorer en
> > http://explorer.msn.es/intl.asp
> >
> > --
> > Please see the official
> > ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Alejandra Pazos Freire
> > INET: [EMAIL PROTECTED]
> >
> > 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: [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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: [EMAIL PROTECTED]
>
> 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: [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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
