On 13 déc, 13:48, vitalis..._at_gmail.com (Jerome Vitalis) wrote:
> Vincent wrote:
> > > In your source database:
>
> > > create table combined_login as
> > > select * from user1.login;
>
> > > insert into combined_login (
> > > select * from user2.login)
>
> > > insert into combined_login (
> > > select * from user2.login)
>
> > > then export combined_login, import it into your target database and
> > > rename it whatever you want.
> > Yes, should work... I had this idea at the begining but I didn't want
> > to duplicate all data, it's why I chose to create a view instead...
> > but maybe I will try this option...
> > thx.
>
> Then create a database link in your target database and use something like:
> create table login as
> select * from user1.login_at_source_db;
>
> insert into login (
> select * from user2.login_at_source_db)
>
> insert into login (
> select * from user3.login_at_source_db)
> -----
> échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/
yes, another way to proceed, thx.
Received on Fri Dec 14 2007 - 05:13:32 CST
