Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Swap Two Tables?

Re: How to Swap Two Tables?

From: RK <rekaben_at_yahoo.com>
Date: 30 Oct 2003 09:15:37 -0800
Message-ID: <239f1935.0310300915.26b01e94@posting.google.com>


Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<kn00qv4nf0rv3trj2n8q9319ul3v6aapuc_at_4ax.com>...
> rekaben_at_yahoo.com (RK) wrote:
>
> ...
> >Well, this newsgroup may have some virus. After I posted my first
> >question, I was bombed by bulk-email-spam.
> >
> No, the newsgroup does not have a virus..However there is a trojan out there ( on folk's workstations that have not been
> keeping up with threats and patches)
> that scans newsgroups for email addresses - So do NOT use your real email address when posting - spoof it in some way
> like rekabenatyahoodotcom
>
>

Well, the interface of posting requires me to put in a true e-amil account, otherwise it won't allow me in. How can you keyin some name like that to make it work for you?

>
> >Now return to my questions. Let me ask them one by one --
> >
> >Fist One:
> >
> >With SQL, how can I compare two table content to see if they are
> >identical or not? If not, can I show their difference using certain
> >SQL commands and dump the output?
> >
> >Thanks.
> I am not sure that SQL alone can do that -
> There are 3rd party apps out there that can ( I seem to remember one called OraCompare - a google search should find out if
> it still exists)
>

You know how I make it: I dump the content into files and compare them with OS tools. I wonder why Oracle does not have it. Anybody any other ideas?

Now suppose I find something different in the two tables, and table A has something table B doesn't have, and vice versa. How can I make the two tables sychronized?

Or if I find out there are even something wrong in the difference (either one of them could be wrong somewhere) and I wish I could drop them to clean up. I am not allowed to create a new table. Then the only thing is the same as above -- to dump them in files and clean up files then load the data back?

No other way of doing that? How about I can create a new table but only with limited allowable space?

Thanks.

RK Received on Thu Oct 30 2003 - 11:15:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US