| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: export multiple tables and import in a single one
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
![]() |
![]() |