Re: How to Swap Two Tables?

to sync the tables, consider using replications (snapshots or materialized views)

to replace a table if there is new data in the 2nd table, if snapshots or some mechanism to keep track of new rows is not possible or practical, use a minus statement to determine if there are differences -- if it would resolve matters to add the new rows to the subject table, you could possibly to something like

    insert into t1 (

        select * from t2
        minus
        select * from t1
        )

or if the reference table's contents need to totally replace the subject table, first use the minus to see if any data has changed, then truncate the subject table and insert the contents of the reference table (see my prior post)

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048


"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:9Q_lb.3878$n95.2249_at_news01.roc.ny...


>

> "RK" <rekaben_at_yahoo.com> wrote in message

news:239f1935.0310231506.181e4b9c_at_posting.google.com...


> > "nobody" <nobody_at_nowhere.com> wrote in message

news:<7mUlb.253604$ko%.218644_at_news04.bloor.is.net.cable.rogers.com>...


> > > tables t1 t2

> > > rename t1 to t3;

> > > rename t2 to t1;

> > > rename t3 to t2;

> > >

> > > "RK" <rekaben_at_yahoo.com> wrote in message

> > > news:239f1935.0310230807.5a9ccbc1_at_posting.google.com...

> > > > Assuming space if not a problem, how can I exchange two table

content


> > > > (two table in same definition and structure) using SQL?

> > > >

> > > > RK

> >

> > Sorry. Maybe my first post question was unclear enough.

> >

> > I have two big tables. I want to compare the two table content to see

> > if they are identical. If they are not, then I should exchange their

> > content.

> >

> > Please tell me how I can do these two steps using SQL. And for the

> > second step, if I am not allowed to create a temp table, how can I do

> > it?

> >

> > Thanks.

> >

> > RK

>

> This post is as unclear as the original post.

>

> exchange means .. you want to put tableB's content into tableA and

tableA's content into tableB.


> Same as swap!

>

> Now I have a feeling that you want to sync tableA from the contents of

tableB.


> i.e. At the end of it all you want to make tableA's content look exactly

like tableB's content?


>

> Does that reflect correctly what you wish to achieve?

>

> Anurag

>

>