Re: export multiple tables and import in a single one

From: gazzag <gareth_at_jamms.org>
Date: Fri, 14 Dec 2007 03:21:11 -0800 (PST)
Message-ID: <79df0144-1273-4658-9b19-87e6e18a710a@s12g2000prg.googlegroups.com>

On 14 Dec, 11:02, Vincent <mortime..._at_hotmail.com> wrote:
> I agree with your algorithm, i'll try again, i should have missed
> something... :-/
> thx.- Hide quoted text -
>
> - Show quoted text -

I've just noticed that I forgot the TOUSER parameter. My post should have read:

Import first table as normal:

imp <user>/<password> file=<filename> fromuser=user1 touser=user tables=login

2. Now that the "login" table exists, a subsequent import will fail unless you use the IGNORE parameter:

imp <user>/<password> file=<filename> fromuser=user2 touser=user tables=login ignore=y

3. As in step 2, to import the final table, you need the IGNORE parameter again:

imp <user>/<password> file=<filename> fromuser=user3 touser=user tables=login ignore=y

That should work. Good luck.

-g Received on Fri Dec 14 2007 - 05:21:11 CST