Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!b40g2000prf.googlegroups.com!not-for-mail
From: onedba@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: export multiple tables and import in a single one
Date: Wed, 12 Dec 2007 03:30:23 -0800 (PST)
Organization: http://groups.google.com
Lines: 3
Message-ID: <37e31949-8963-445a-afc6-985e9b61a81a@b40g2000prf.googlegroups.com>
References: <b8244a60-dc71-4471-b4a8-a16d3739ee19@q77g2000hsh.googlegroups.com> 
 <e9b7dd48-e129-4bd3-8e5a-121e4fc53a49@f3g2000hsg.googlegroups.com>
NNTP-Posting-Host: 121.0.31.121
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197459024 18245 127.0.0.1 (12 Dec 2007 11:30:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Dec 2007 11:30:24 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b40g2000prf.googlegroups.com; posting-host=121.0.31.121; 
 posting-account=Cw3VZwoAAADDYAP2SNKqjbaD60Zu-BDn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.8.1.11) 
 Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:438985
X-Received-Date: Wed, 12 Dec 2007 06:30:24 EST (text.usenetserver.com)

and i have an other method :
what about insert into ..as select ...?