Re: copy data from one database to another

Another way to do this is with the SQL*Plus copy command:

copy from scott/tiger_at_connect_string replace cbr_user - using select * from cbr_user

use the variables ARRAYSIZE and COPYCOMMIT to set the size of batches and how often a commit is performed. If COPYCOMMIT is zero, then the copy command will not commit until all rows have been coppied.

(very useful if rollback segment usage is an issue)

cheers,
John.

TurkBear <johng_at_mm.com> wrote in message news:395120f5.9500270_at_super.news-ituk.to...
>
> 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 Thu Jun 22 2000 - 00:00:00 CDT