Re: [Q] How to duplicat all data from one DB to another DB
From: E. Sedney <101740.245_at_CompuServe.COM>
Date: 1996/05/01
Message-ID: <4m7vqt$5bj$2_at_mhadf.production.compuserve.com>#1/1
Date: 1996/05/01
Message-ID: <4m7vqt$5bj$2_at_mhadf.production.compuserve.com>#1/1
Hi
you can use import/export with the fromuser and touser option.
You can also insert into the tables (training) by using database
links, like:
insert into table a
select * from remote_table_a_at_dblink
where rownum <= xxxxxxx;
Good luck
E. Sedney
Oracle
Received on Wed May 01 1996 - 00:00:00 CEST