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: Wed, 12 Dec 2007 07:21:05 -0800 (PST)
Message-ID: <c4defebf-db69-4c8d-b99d-0e060296a4b4@w40g2000hsb.googlegroups.com>


On 12 déc, 14:46, gazzag <gar..._at_jamms.org> wrote:
> On 12 Dec, 12:44, Vincent <mortime..._at_hotmail.com> wrote:
>
> > thanks for you suggestion. I tried that but th result is not as
> > expected. It effectively ignores errors but it doesn't append data to
> > my destination table :-/
> > It tries to create the table each time ("create table", not a "create
> > or replace table")
>
> > I'll continue my investigation.
>
> Please post the exact command that you're using to run the import and
> the output that you see. It should work as I've described.

imp userid=admin/password file=login.dmp tables=login indexes=N fromuser=user1 touser=user grants=N ignore=Y Received on Wed Dec 12 2007 - 09:21:05 CST

Original text of this message

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