I have to move around 1 million rows of table a into table b (append). They both reside on two different servers. I need to perform some edits on the data in table a. More precisely, an entire column needs to be changed. Table A rows need to be deleted after the completion.
I need to move only some rows from table A. Not all. Table B structure is not the same as Table A (one column appears at a different position). I looked at the documentations. SQL*Loader can be used to load records into Table B. But, how can we get records from Table A into a file (that SQL*Loader can read)?
I didn't find anything that describes a filter (select, where clause) in export Utility. So, I am doubtful, export utility can be used to load rows records from table a into a flatfile.
Could you please tell me a fast and efficient method? Thank you.
I need to move only some rows from table A. Not all. Table B structure is not the same as Table A (one column appears at a different position). I looked at the documentations. SQL*Loader can be used to load records into Table B. But, how can we get records from Table A into a file (that SQL*Loader can read)?
I didn't find anything that describes a filter (select, where clause) in export Utility. So, I am doubtful, export utility can be used to load rows records from table a into a flatfile.
Could you please tell me a fast and efficient method? Thank you.