Copy command

All,
[Quoted]   HELP!! Desparate help needed - have to implement this in the Production database

I am using the Copy command in Sql*Plus to copy data between tables which belong to the same user, same tablespace, etc. In other words , it is a local copy. I do this to migrate data from the old database structure to a new structure.

First, I used

Copy Insert <new_table> Using Select * from <old_table>

It said, have to use one of From or To

So,

Copy from user/pwd Insert <new_table> Using Select * from <old_table>

It said, have to specify the _at_database specification

So, I created an entry in tnsnames.ora, create a public database link from the Oracle user to itself. When I use this database link to describe a table or select from a table as in

desc table_at_dblink or select * from table_at_dblink

it works fine.

But when I used,

copy from user/pwd_at_dblink to user/pwd_at_dblink - Insert new_table-
 Select * from old_table;

It gave ORA-12154

Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80)  

ERROR:
ORA-12154: TNS:could not resolve service name

I have to get this done NOW. Please help!

Thanks a lot,

Nigam Received on Fri Jan 30 1998 - 00:00:00 CET