Copy Dilemma

From: Schrödinger's Cat <72446.2772_at_compuserve.com>
Date: Wed, 14 Aug 2002 06:03:51 GMT
Message-ID: <xpm69.2815$cm5.850741353@twister1.starband.net>

I am trying to copy from one database to another. The origin is an 8i instance and the destination is an 9i instance on another machine. If I am logged on to the destination machine as a user with sufficient privileges and type:

copy from user/pw_at_origindb create tablename using select * from tablename;

I get an error ORA- 01002

On the other hand if I am logged on to the source database (remotely from the destination machine), and type:

copy to user/pw_at_destdb create tablename using select * from tablename;

it works fine!

Weird!!!! Anyone have any ideas what is happening???? Received on Wed Aug 14 2002 - 01:03:51 CDT