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 "copy" as a partitioned table.
For example, the method would not work with this table (because of the two unique keys):
create table t (a number unique, b number unique) ;
If your database version is 8.0 there are even more restrictions on what kind of table you can use in an exchange partition command (IIRC any FK constraint will prevent you from using the table in an exchange partition.)
> -----Original Message-----
> Stephane Paquette
>
> 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 is just an update in the data dictionnary. No data
> is physically
> moved.
>
> -----Original Message-----
> Nancy Hu
>
> We have an Oracle database that is a kind of data warehouse.
> We load data
> from mainframe into the database every day. The following
> are the steps how
> we load data currently:
>
> 1. get the data file from Datacom
> 2. ftp the data file from mainframe to the Sun machine where
> the Oracle
> database resides
> 3. truncate all tables in Oracle database
> 4. load the data into Oracle with SQL LOADER
>
> Most tables in the Oracle database don't have primary key.
> Tables are not
> available during the loading that gives us problem for our 24x7
> availability. Therefore, we would like to change our loading
> method. Any
> ideas would be highly appreciated.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 06 2003 - 17:29:24 CDT
