Re: Copying tables
From: Jon Armstrong <jma00002_at_rochester.rr.com>
Date: Tue, 19 Mar 2002 17:10:42 GMT
Message-ID: <miKl8.121099$nl1.21412325_at_typhoon.nyroc.rr.com>
Date: Tue, 19 Mar 2002 17:10:42 GMT
Message-ID: <miKl8.121099$nl1.21412325_at_typhoon.nyroc.rr.com>
John,
There are a number of ways to do this. One rather easy way is to use the copy command in sqlplus.
set copycommit 1
set arraysize 1000
copy from user/password_at_database -
create TableName using -
select * from RemoteTableName;
Regards... Jon
"Cardinal" <john.menken_at_ceridian.com> wrote in message
news:a7b860fd.0203180824.1972f090_at_posting.google.com...
> I have a table in one of my Oracle accounts called CRM and I want to
> copy this table to another one of my Oracle accounts. Is there an easy
> way to do this? Thanks.
Received on Tue Mar 19 2002 - 18:10:42 CET