Re: copy 2 big tables into one in oracle 9.2

append hint will write the data over the HWM. This minimizes undo and thus reduces redo also.

However, append might not work as good if you have indexes on that table. If you have that then have a look here (mark indexes unusable, alter session set skip_unusable_indexes=true ... insert .. rebuild indexes etc.):

http://asktom.oracle.com/pls/ask/f?p=4950:8:13633811699375894342::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3224814814761

Anurag Received on Tue Apr 04 2006 - 09:47:52 CDT