Re: copy data from one database to another

From: <dwilliams_at_lifetouch.com>
Date: 2000/06/23
Message-ID: <8j0jqd$kk0$1@nnrp1.deja.com>#1/1

Log into k51
INSERT INTO CBR_USER SELECT * FROM CBR_USER_at_K52; COMMIT; INSERT INTO CBR_USER SELECT * FROM CBR_USER_at_K52 WHERE RELEASE_ID = 123456;
COMMIT; This will work as long as your data can be committed in one rollback space.

In article <7n62ls0rcfri79pn17t6vvaf53eb2eri4s_at_4ax.com>, Steve . <syarbrou_at_enteract.com> wrote:
> I have two database instances k51 and k52 on the same machine. I have
> a database link from k51 to k52. Both databases have the same table
> cbr_user. If I wanted to copy everything from cbr_user from one k51
> to k52, how would I script that? Thanks.
>
> Also, what If I wanted to do the above, but copy only items that had a
> release_id value of 123456? Thanks again.
>
> Steve
>
> Newsgroup replies preferred. Remove nospam when replying thru email.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 23 2000 - 00:00:00 CDT