Re: How to Swap Two Tables?

From: mcstock <mcstock_at_enquery.com>
Date: Thu, 30 Oct 2003 12:23:26 -0500
Message-ID: <37SdnTgchemo1DyiRVn-sg@comcast.com>

regarding comparison and swapping, please see my two earlier posts

regarding creating a table and limited space

do you mean that your oracle account privileges do not include CREATE TABLE? then negotiate with your DBA (aka 'Donuts Buy Attention')

do you mean how to limit space usage when creating a table? the look into the STORAGE clause as well as the TABLESPACE clause under the CREATE TABLE command

"RK" <rekaben_at_yahoo.com> wrote in message news:239f1935.0310300915.26b01e94_at_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:23:26 CST