Hi Guys,
Can you tell me what is wrong with this SQL statement?
copy from scott/tiger@dev01 to user1/temp@prod1 replace casting using SELECT * FROM casting;
Chintz
Printable View
Hi Guys,
Can you tell me what is wrong with this SQL statement?
copy from scott/tiger@dev01 to user1/temp@prod1 replace casting using SELECT * FROM casting;
Chintz
As I have never used the command I had to look it up.Quote:
Originally posted by Chintz
Hi Guys,
Can you tell me what is wrong with this SQL statement?
copy from scott/tiger@dev01 to user1/temp@prod1 replace casting using SELECT * FROM casting;
Chintz
Quote:
COPY
The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8. The COPY command is likely to be made obsolete in a future release. For COPY command details and syntax, see Appendix B, "SQL*Plus COPY Command".
The syntax is not erroring out on the copy command. I am getting the following error:
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-00955: name is already used by an existing object
Chintz
Maybe, just maybe there is already a table in your target schema called Casting... and i'm guessing that replace doesn't work as you think it ought to... (like in a create or replace view)...
it shud replace the contents by drop and recreate..
Can you post result of below queryQuote:
REPLACE
Replaces destination_table and its contents with the rows from query. If destination_table does not exist, COPY creates it. Otherwise, COPY drops the existing table and replaces it with a table containing the copied data.
Select Object_Name, Object_Type From All_Objects Where Owner = 'USER1' And Object_Name = 'CASTING';
Abhay.