Re: copy data from one database to another

Log into K52
assume db link name to K51 is remotek

do:

insert into cbr_user select * from cbr_user_at_remotek;

to selectively insert add a where clause so:

insert into cbr_user select * from cbr_user_at_remotek where release_id = 123456;

( on this one you may have to use an alias for the remote table so there is no ambiguity as to which release_id is referenced by the where clause)

hth,

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.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Jun 21 2000 - 00:00:00 CDT