Hi all,

I have a question that's bugging me for a while and I was wondering if somebody could help me. I have to perform a table copy from Table A on Oracle 8i at one location to Table B on Oracle 8i at some other location. Both the tables exist and are currently used. Now, I was asked to find the right way to copy. Earlier, they tried and it took 2 days to transfer 1/2 million records. Both the tables have same columns but for one column which appears out of order in Table B. I am thinking of using COPY command in SQL*PLUS.

Now, my question is: How should this be performed? When I see the row count on both the tables, it changes every 2 secs. i.e thy are being used.

Please give me some steps. Will appreciate any help. Thanks.