From: john@ezsql.net (John Dorlon)
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQLPLUS Copy Command
Date: 8 Aug 2001 12:11:16 -0700
Organization: http://groups.google.com/
Lines: 11
Message-ID: <a8097a33.0108081111.1c5a7c5@posting.google.com>
References: <730cf4e9.0108021234.649a5bb9@posting.google.com>
NNTP-Posting-Host: 204.151.230.97
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997297876 3125 127.0.0.1 (8 Aug 2001 19:11:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 19:11:16 GMT


mschuster@canberra.com (Mike) wrote in message news:<730cf4e9.0108021234.649a5bb9@posting.google.com>...
> I want to copy all tables from one database to another using the
> sqlplus copy command. Is this possible?  Can someone give me an
> example? Thanks.


I think it would be easier to use exp/imp to copy all tables from
one db to another.  You won't have to worry about LONGs or LOBs or
any special data types.

-John