Re: SQLPLUS Copy Command
From: Michael Nhan <mnhan_at_watson.wustl.edu>
Date: Tue, 07 Aug 2001 14:44:13 -0500
Message-ID: <3B70450D.35F885B2_at_watson.wustl.edu>
Date: Tue, 07 Aug 2001 14:44:13 -0500
Message-ID: <3B70450D.35F885B2_at_watson.wustl.edu>
Venki Ramachandran wrote:
> I think you have to use the copy command for each table. So you will
> have to execute the copy command the same number of times as the number
> of tables. I don't think that here is one command to copy all the
> tables.
>
> Mike wrote:
>
> > 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.
Agreed, also I do not think the copy command will let you copy tables with long raws, clob, or blob fields.
Michael Received on Tue Aug 07 2001 - 21:44:13 CEST