it shud replace the contents by drop and recreate..
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.
Can you post result of below query
Select Object_Name, Object_Type From All_Objects Where Owner = 'USER1' And Object_Name = 'CASTING';
Abhay.
funky...
"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"