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;
As I have never used the command I had to look it up.
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".
it shud replace the contents by drop and recreate..
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.
Can you post result of below query
Select Object_Name, Object_Type From All_Objects Where Owner = 'USER1' And Object_Name = 'CASTING';
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"