export multiple tables and import in a single one

Hello,

I would like to export tables which have the same name, say "login" and then import them in a single table in another database. As tables have the same name and the same structure, they're owned by different users. All my "login" tables have the same structure.

ex:
source database: user1.login, user2.login, user3.login destination database: user.login

I explored two main potential solutions:

1. create a view on a source database which is a union of select from all the source tables. The problem here is that exporting a view does not export results but only the structure of this view. I found no way to export data as a table.
2. export all the tables with the exp parameter: tables=user1.login,user2.login,user3.login But while importing in the destination with fromuser=user1 touser=user tables=login, the first one is created but the second import generate an error because object already exists. I hoped that it would have appended data to existing table but it doesn't seem to be the case...

I looked for other solutions on forums but unsuccessfully so far... Did someone experience the same problem or have some way to explore ?

Thanks per advance. Received on Wed Dec 12 2007 - 05:17:55 CST