Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!newsfeed.freenet.de!border2.nntp.ams.giganews.com!nntp.giganews.com!newshub2.home.nl!newshub1.home.nl!home.nl!not-for-mail
From: Frank van Bortel <frank.van.bortel@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: export multiple tables and import in a single one
Date: Wed, 12 Dec 2007 20:52:36 +0100
Organization: @Home Benelux
Lines: 20
Message-ID: <fjpe5v$lo5$1@news5.zwoll1.ov.home.nl>
References: <b8244a60-dc71-4471-b4a8-a16d3739ee19@q77g2000hsh.googlegroups.com> 	<e9b7dd48-e129-4bd3-8e5a-121e4fc53a49@f3g2000hsg.googlegroups.com> <e3a0c8f2-e29a-4b38-862d-464669e4e4f2@18g2000hsf.googlegroups.com>
Reply-To:  frank.van.bortel@gmail.com
NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: news5.zwoll1.ov.home.nl 1197489151 22277 82.75.92.64 (12 Dec 2007 19:52:31 GMT)
X-Complaints-To: usenet@corp.home.nl
NNTP-Posting-Date: Wed, 12 Dec 2007 19:52:31 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.13 (Windows/20070809)
In-Reply-To: <e3a0c8f2-e29a-4b38-862d-464669e4e4f2@18g2000hsf.googlegroups.com>
X-Enigmail-Version: 0.94.1.2
Bytes: 1765
Xref: usenetserver.com comp.databases.oracle.server:439007
X-Received-Date: Wed, 12 Dec 2007 14:52:32 EST (text.usenetserver.com)

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...