Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export multiple tables and import in a single one

Re: export multiple tables and import in a single one

From: gazzag <gareth_at_jamms.org>
Date: Wed, 12 Dec 2007 03:24:36 -0800 (PST)
Message-ID: <e9b7dd48-e129-4bd3-8e5a-121e4fc53a49@f3g2000hsg.googlegroups.com>


On 12 Dec, 11:17, Vincent <mortime..._at_hotmail.com> wrote:
> 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.

Use parameter IGNORE=Y. This causes object creation errors to be ignored.

HTH -g Received on Wed Dec 12 2007 - 05:24:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US