Re: SQLPLUS Copy Command

From: John Dorlon <john_at_ezsql.net>
Date: 8 Aug 2001 12:11:16 -0700
Message-ID: <a8097a33.0108081111.1c5a7c5_at_posting.google.com>

mschuster_at_canberra.com (Mike) wrote in message news:<730cf4e9.0108021234.649a5bb9_at_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 Received on Wed Aug 08 2001 - 21:11:16 CEST

This message: [ Message body ]
Next message: Willy Gielen: "Re: using microsoft odbc vs oracle odbc"
Previous message: Keith Tai: "Oracle Replication Manager"
In reply to: Mike: "SQLPLUS Copy Command"
In reply to Mike: "SQLPLUS Copy Command"
Next in thread: Willy Gielen: "Re: using microsoft odbc vs oracle odbc"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message