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: Vincent <mortimer59_at_hotmail.com>
Date: Fri, 14 Dec 2007 03:02:09 -0800 (PST)
Message-ID: <8add15c3-9158-43af-a34c-e8f87a1c7c2e@d4g2000prg.googlegroups.com>


On 13 déc, 11:34, gazzag <gar..._at_jamms.org> wrote:
> On 13 Dec, 09:19, Vincent <mortime..._at_hotmail.com> wrote:
>
>
>
> > well, right, but I was thinking about merging data in another table
> > after import.
> > imp 1st table -> add data to a table merged_data
> > imp 2nd table -> add data to merged_data
> > ...
>
> > it's what I did actually, but I added a "drop table" between each
> > import. It works, although I'm not sure it's the best solution...
>
> > Thanks :-)
>
> The steps you need to take are as follows:
>
> 1. Import first table as normal:
>
> imp <user>/<password> file=<filename> fromuser=user1 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 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 tables=login
> ignore=y
>
> If the above fails, there's something else you're not telling us.
>
> HTH
>
> -g

I agree with your algorithm, i'll try again, i should have missed something... :-/
thx. Received on Fri Dec 14 2007 - 05:02:09 CST

Original text of this message

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