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.
Thanks very much for the fast reply. If you can also comment on my other questions it would be great. Normally in a prod. environment, what's the procedure? Both the tables are in use. I donot know if it is dba related only. However, I am supposed to propose a solution.
The req. is that I need o copy all records with creation date less than current date from A to B. This is a one time backup ONLY. Both the tables have same columns. Only one field is out of order. Both have PKS. One in each and they are same.