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: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 12 Dec 2007 20:52:36 +0100
Message-ID: <fjpe5v$lo5$1@news5.zwoll1.ov.home.nl>


Vincent 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 :-/

Then, you have another error, you are not telling us. Like ORA-00001

> It tries to create the table each time ("create table", not a "create
> or replace table")
>

No such statement exists; it it did, would would you suggest the replace part would do with your data?!? Right.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Dec 12 2007 - 13:52:36 CST

Original text of this message

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