Re: export multiple tables and import in a single one

From: Jerome Vitalis <vitalis..._at_gmail.com>
Date: 13 Dec 2007 12:48:51 GMT
Message-ID: <47612a33$0$5113$426a74cc@news.free.fr>

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/ Received on Thu Dec 13 2007 - 06:48:51 CST