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


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

Original text of this message