-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: data loading
Date: Mon, 06 Oct 2003 14:29:24 -0800
If you choose to implement this method, make sure that all the tables can
be in the exchange partition command. The exchange partition command has
certain
You can use the partitionning option.
Load into a 1 partitionned table then do a partition exchange with the
target table.
It allows you to have the current data live while loading into the
partitionned table.
Once the load is loaded just exchange the partition with the table, it is
fast as it
If you choose to implement this method, make sure that all the tables can be in the
exchange partition command. The exchange partition command has certain requirements to
be able to complete the exchange (similarity of indexes and constraints), and the
table has to be suitable for building a
